Excel Math Functions

Excel Math Functions - Links to Each of the Built-In Math & Trig Functions

FunctionPurposeParam,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 π
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