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 base10 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 π 

RADIANS 
Converts an angle into radians 
angle 
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 