Math and Trig Functions
TRUNC
Truncates a number to an integer by removing the decimal, or fractional, part of the …
SUMX
Returns the sum of an expression evaluated for each row in a table.
SUM
Adds all the numbers in a column.
SQRT
Returns the square root of a number.
SIGN
Determines the sign of a number, the result of a calculation, or a value in …
ROUNDUP
Rounds a number up, away from 0 (zero).
LCM
Returns the least common multiple of integers. The least common multiple is the smallest positive …
ISO.CEILING
Rounds a number up, to the nearest integer or to the nearest multiple of significance.
LN
Returns the natural logarithm of a number. Natural logarithms are based on the constant e …
LOG
Returns the logarithm of a number to the base you specify.
LOG10
Returns the base-10 logarithm of a number.
MROUND
Returns a number rounded to the desired multiple.
ODD
Returns number rounded up to the nearest odd integer.
PI
Returns the value of Pi, 3.14159265358979, accurate to 15 digits.
POWER
Returns the result of a number raised to a power.
PRODUCT
Returns the product of the numbers in a column.
PRODUCTX
Returns the product of an expression evaluated for each row in a table.
QUOTIENT
Performs division and returns only the integer portion of the division result. Use this function …
RADIANS
Converts degrees to radians.
RAND
Returns a random number greater than or equal to 0 and less than 1, evenly …
RANDBETWEEN
Returns a random number in the range between two numbers you specify.
ROUND
Rounds a number to the specified number of digits.
ROUNDDOWN
Rounds a number down, toward zero.
INT
Rounds a number down to the nearest integer.
GCD
Returns the greatest common divisor of two or more integers. The greatest common divisor is …
FLOOR
Rounds a number down, toward zero, to the nearest multiple of significance.
ACOS
Returns the arccosine, or inverse cosine, of a number. The arccosine is the angle whose …
ABS
Returns the absolute value of a number.
ACOSH
Returns the inverse hyperbolic cosine of a number. The number must be greater than or …
ACOT
Returns the principal value of the arccotangent, or inverse cotangent of a number.
ACOTH
Returns the inverse hyperbolic cotangent of a number.
ASIN
Returns the arcsine, or inverse sine, of a number. The arcsine is the angle whose …
ASINH
Returns the inverse hyperbolic sine of a number. The inverse hyperbolic sine is the value …
ATAN
Returns the arctangent, or inverse tangent, of a number. The arctangent is the angle whose …
ATANH
Returns the inverse hyperbolic tangent of a number. Number must be between -1 and 1 …
CEILING
Rounds a number up, to the nearest integer or to the nearest multiple of significance.
COMBIN
Returns the number of combinations for a given number of items. Use COMBIN to determine …
COMBINA
Returns the number of combinations (with repetitions) for a given number of items.
COS
Returns the cosine of the given angle.
COSH
Returns the hyperbolic cosine of a number.
CURRENCY
Evaluates the argument and returns the result as currency data type.
DEGREES
Converts radians into degrees.
DIVIDE
Performs division and returns alternate result or BLANK() on division by 0.
EVEN
Returns number rounded up to the nearest even integer. You can use this function for …
EXP
Returns e raised to the power of a given number. The constant e equals 2.71828182845904, …
FACT
Returns the factorial of a number, equal to the series 1*2*3*...* , ending in the …