# Math Function Purpose Param,Optional
ABS Find the absolute value of a number number
CEILING Round a number up to the nearest specified multiple number multiple
COS Get the cosine of an angle number
DEGREES Converts an angle into degrees angle
EVEN Round a number up to the next even integer number
EXP Find the value of e raised to the power of a number number
FACT Find the factorial of a number number
FLOOR Round a number down to the nearest specified multiple number multiple
GCD Get the greatest common divisor of two or more numbers number1number2
INT Get the integer part of a decimal by rounding down number
LCM Get the least common multiple or two or more numbers number1number2
LOG10 Get the base-10 logarithm of a number number
MOD Get the remainder from division number divisor
MROUND Round a number to the nearest specified multiple number multiple
ODD Round a number up to the next odd integer number
PI Get the value of π
RAND Get a random number between 0 and 1
RANDBETWEEN Get a random integer between two values bottom top
ROUND Round a number to a given number of digits number num_digits
ROUNDDOWN Round a number down to a given number of digits number num_digits
ROUNDUP Round a number up to a given number of digits number number_digits
SIGN Get the sign of a number. number
SIN Get the sine of an angle number
SQRT Find the positive square root of a number number
SUBTOTAL Get a subtotal in a list or database function_num ref1ref2
SUM Add numbers together number1number2 number3
SUMIF Sum numbers in a range that meet supplied criteria range criteriasum_range
SUMPRODUCT Multiply, then sum arrays array1array2
TAN Get the tangent of an angle. number 