The functions have been grouped by category, to help you to find the function you need. Each function link provides a full description of the function, with examples of use and common errors. Note that some of the Excel functions listed below are new to Excel 2013 or Excel 2016, so are not available in earlier versions of Excel.

 

Basic Numeric Information

ABS
Returns the absolute value (i.e. the modulus) of a supplied number.

SIGN
Returns the sign (+1, -1 or 0) of a supplied number.

GCD
Returns the Greatest Common Divisor of two or more supplied numbers.

LCM
Returns the Least Common Multiple of two or more supplied numbers.

 

Basic Mathematical Operation

SUM
Returns the sum of a supplied list of numbers.

PRODUCT
Returns the product of a supplied list of numbers.

POWER
Returns the result of a given number raised to a supplied power.

SQRT
Returns the positive square root of a given number.

QUOTIENT
Returns the integer portion of a division between two supplied numbers.

MOD
Returns the remainder from a division between two supplied numbers.

AGGREGATE
Performs a specified calculation (e.g. the sum, product, average, etc.) for a list or database, with the option to ignore hidden rows and error values (New in Excel 2010).

SUBTOTAL
Performs a specified calculation (e.g. the sum, product, average, etc.) for a supplied set of values.

 

Rounding Function

CEILING
Rounds a number away from zero (i.e. rounds a positive number up and a negative number down), to a multiple of significance.

CEILING.PRECISE
Rounds a number up, regardless of the sign of the number, to a multiple of significance (New in Excel 2010).

CEILING.MATH
Rounds a number up to the nearest integer or to the nearest multiple of significance (New in Excel 2013).

FLOOR
Rounds a number towards zero, (i.e. rounds a positive number down and a negative number up), to a multiple of significance.

FLOOR.PRECISE
Rounds a number down, regardless of the sign of the number, to a multiple of significance (New in Excel 2010).

FLOOR.MATH
Rounds a number down, to the nearest integer or to the nearest multiple of significance (New in Excel 2013).

ODD
Rounds a number away from zero (i.e. rounds a positive number up and a negative number down), to the next odd number.

EVEN
Rounds a number away from zero (i.e. rounds a positive number up and a negative number down), to the next even number.

ROUND
Rounds a number up or down, to a given number of digits.

ROUNDUP
Rounds a number away from zero (i.e. rounds a positive number up and a negative number down), to a given number of digits.

ROUNDDOWN
Rounds a number towards zero, (i.e. rounds a positive number down and a negative number up), to a given number of digits.

INT
Rounds a number down to the next integer.

TRUNC
Truncates a number towards zero (i.e. rounds a positive number down and a negative number up), to the next integer.

 

Random Numbers

RAND
Returns a random number between 0 and 1.

RANDBETWEEN
Returns a random number between two given integers.

 

Conditional Sum Functions

SUMIF
Adds the cells in a supplied range, that satisfy a given criteria.

SUMIFS
Adds the cells in a supplied range, that satisfy multiple criteria (New in Excel 2007).

 

Advance Mathematical operations

SUMPRODUCT
Returns the sum of the products of corresponding values in two or more supplied arrays.

SUMSQ
Returns the sum of the squares of a supplied list of numbers.

SUMX2MY2
Returns the sum of the difference of squares of corresponding values in two supplied arrays.

SUMX2PY2
Returns the sum of the sum of squares of corresponding values in two supplied arrays.

SUMXMY2
Returns the sum of squares of differences of corresponding values in two supplied arrays.

SERIESSUM
Returns the sum of a power series.

 

Trigonometry Functions

PI
Returns the constant value of pi

SQRTPI
Returns the square root of a supplied number multiplied by pi

DEGREE
Converts Radians to Degrees

RADIANS
Converts Degrees to Radians

COS
Returns the Cosine of a given angle

ACOS
Returns the Arccosine of a number

COSH
Returns the hyperbolic cosine of a number

ACOSH
Returns the inverse hyperbolic cosine of a number

SEC
Returns the secant of an angle (New in Excel 2013)

SECH
Returns the hyperbolic secant of an angle (New in Excel 2013)

CSC
Returns the cosecant of an angle (New in Excel 2013)

CSCH
Returns the hyperbolic cosecant of an angle (New in Excel 2013)

SIN
Returns the Sine of a given angle

ASIN
Returns the Arcsine of a number

SINH
Returns the Hyperbolic Sine of a number

ASINH
Returns the Inverse Hyperbolic Sine of a number

TAN
Returns the Tangent of a given angle

ATAN
Returns the Arctangent of a given number

TANH
Returns the Hyperbolic Tangent of a given number

ATANH
Returns the Inverse Hyperbolic Tangent of a given number

COT
Returns the cotangent of an angle (New in Excel 2013)

COTH
Returns the hyperbolic cotangent of an angle (New in Excel 2013)

ACOT
Returns the arccotangent of a number (New in Excel 2013)

ACOTH
Returns the hyperbolic arccotangent of a number (New in Excel 2013)

 

Exponents and logarithm

EXP
Returns e raised to a given power.

LN
Returns the natural logarithm of a given number.

LOG
Returns the logarithm of a given number, to a specified base.

LOG10
Returns the base 10 logarithm of a given number.

 

Factorials

FACT
Returns the Factorial of a given number.

FACTDOUBLE
Returns the Double Factorial of a given number.

MULTINOMIAL
Returns the Multinomial of a given set of numbers.

 

Number Conversion

BASE
Converts a number into a text representation, with the supplied base (New in Excel 2013).

DECIMAL
Converts a text representation of a number in a specified base into a decimal number (New in Excel 2013).

ARABIC
Converts a Roman numeral to an Arabic numeral (New in Excel 2013).

ROMAN
Returns a text string depicting the roman numeral for a given number.