Number functions

Number functions are used to manipulate numeric data.

Function

Purpose

Abs

Returns the absolute value of a number.

Ceiling

Returns a number rounded up to the next integer.

Combination

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

Div

Returns the next lowest integer value after dividing a number by a divisor.

Exp

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

Factorial

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

Floor

Returns a number rounded down to the next lower integer.

Int

Drops digits to the right of the decimal point and returns the integer part of a number without rounding.

Lg

Returns the base-2 logarithm of a number.

Ln

Returns the base-e (natural) logarithm of a number.

Log

Returns the base-10 (common) logarithm of a number.

Mod

Returns the remainder after a number is divided by a divisor.

Random

Returns a number between 0 and 1, including 0 but not including 1.

Round

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

SetPrecision

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

Sign

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

Sqrt

Calculates the square root of a number.

Truncate

Returns a number truncated to the specified number of decimal places.