Home > 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 (a positive number) of a number.
Ceiling	A number rounded up to the next integer.
Combination	The number of ways to uniquely choose a specified number of items from a set of specified size.
Div	An integer of the specified number divided by the divisor.
Exp	The value of the constant e (the base of the natural logarithm, equal to 2.7182818) raised to the power of a specified number.
Factorial	The factorial of a specified number stopping at 1, or at a specified number factorial.
Floor	A number rounded down to the next lower integer.
Int	The whole number (integer) part of the value you specify, without rounding.
Lg	The base 2 logarithm of the specified number, which can be any positive value.
Ln	The base-e (natural) logarithm of the specified number.
Log	The common logarithm (base 10) of the specified number, which can be any positive value.
Mod	The remainder after a specified number is divided by divisor.
Random	A random number between zero and one.
Round	A number rounded off to the specified precision (number of decimal places).
SetPrecision	Any math functions contained within the specified expression to the specified digits of precision, if the math function supports extended precision.
Sign	One of three possible values: -1 when the specified number is negative, 0 when it's zero, and 1 when it's positive.
Sqrt	The square root of a number.
Truncate	A number truncated to the specified precision (number of decimal places), without evaluating the value of the discarded digits.

Related topics 

About functions

About formulas