Inputs Allowed in Formulas

 
 
 

In addition to the quantity values, operators, and object properties that are available in the Formula Editor, you can enter any of the following mathematical functions to create formulas:

Name Description
Abs Returns the absolute value of a specified number.
Acos Returns the angle whose cosine is the specified number.
Asin Returns the angle whose sine is the specified number.
Atan Returns the angle whose tangent is the specified number.
Atan2 Returns the angle whose tangent is the quotient of 2 specified numbers.
Ceiling Returns the smallest integer greater than or equal to the specified number.
Cos Returns the cosine of the specified angle.
Cosh Returns the hyperbolic cosine of the specified angle.
Exp Returns e raised to the specified power.
Floor Returns the largest integer less than or equal to the specified number.
Log Returns the logarithm of a specified number.
Log10 Returns the base 10 logarithm of a specified number.
Max Returns the larger of 2 specified numbers.
Min Returns the smaller of 2 numbers.
Pow Returns a specified number raised to the specified power.
Round Rounds a value down to the nearest integer or specified number of decimal places.
Sin Returns the sine of the specified angle.
Sinh Returns the hyperbolic sine of the specified angle.
Sqrt Returns the square root of a specified number.
Tan Returns the tangent of the specified angle.
Tanh Returns the hyperbolic tangent of the specified angle.