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 …