Numeric Functions

Home   Back   Next  

Working with Formulas > Functions Used in Formulas > Numeric Functions

 

Numeric functions are used in working with numeric data types (e.g., rounding a number or calculating the power of a number).  Below are the numeric functions supported in the software:

 

 

Function Name

Type

Description

Abs()

Numeric

Calculates the absolute value of a number

Acos()

Numeric

Calculates the arc cosine of a number

Asin()

Numeric

Calculates the arc sine of a number

Atan()

Numeric

Calculates the arc tangent of a number

Ceiling()

Numeric

Calculates the smallest number greater than or equal to an input number

Cos()

Numeric

Calculates the cosine of a number

Exp()

Numeric

Calculates the constant E raised to a power of a number

Floor()

Numeric

Calculates the largest number less than or equal to an input number

Ln()

Number

Calculates the natural log of a number

Log()

Numeric

Calculates the logarithm of a number in a specified base

Mod()

Numeric

Calculates the remainder of the numerator divided by the denominator

Pi()

Numeric

Returns an approximation of the number Pi

Power()

Numeric

Calculates the base raised to a power of a number

Rand()

Numeric

Calculates a random number between zero and one

Round()

Numeric

Rounds a number to a specified precision

Sign()

Numeric

Returns the sign of a number

Sin()

Numeric

Returns the sine of a number

Tan()

Numeric

Calculates the tangent of a number

Trunc()

Numeric

Truncates a number to a specified precision