Reference > Functions reference > Number functions
 

Number functions

Number functions are used to manipulate numeric data.

Click a function name for details.

 

This function

Returns

Abs

The absolute value of a number.

Ceiling

A number rounded up to the next integer.

Combination

The number of unique ways to choose numberOfChoices items from a set of setSize.

Div

The next lowest integer value after dividing a number by a divisor.

Exp

The value of the constant e raised to the power of a number.

Factorial

The factorial of a number stopping at 1 or at the optional numberOfFactors.

Floor

A number rounded down to the next lower integer.

Int

The integer part of a number without rounding.

Lg

The base-2 logarithm of a number.

Ln

The base-e (natural) logarithm of a number.

Log

The base-10 (common) logarithm of a number.

Mod

The remainder after a number is divided by a divisor.

Random

A number between 0 and 1, including 0 but not including 1.

Round

A number rounded to the specified precision (number of decimal places).

SetPrecision

Any math function with a precision of 16 to 400 digits to the right of the decimal point.

Sign

-1 when a number is negative, 0 when zero, and 1 when positive.

Sqrt

The square root of a number.

Truncate

A number truncated to the specified number of decimal places.

Related topics 

About functions

About formulas