Excel Mathematical Functions

Special

Excel Functions

2003

Special

Excel Functions

2007

Lesson 8: Excel Spreadsheets Mathematical Functions (59)

In annex 8 you have found a description of all 50 Excel functions in the "Mathematical" category. Below is the list of the 9 most useful ones. See more on the very powerful SUMPRODUCT Function in Excel in lesson 11, more on the SUBTOTAL function in lesson 13, more on the obsolete SUMIF function in lesson 15 and more on the new SUMIFS function in lesson 24.

Functions	What it Does
SUM	Adds its arguments
SUMPRODUCT	The most powerful and useful function in Excel
ROUND	Rounds a number to a specified number of digits
ROUNDUP	Rounds a number up, away from zero
SUBTOTAL	Returns a subtotal of a filtered list or database)
TRUNC	Truncates a number to an integer
INT	Rounds a number down to the nearest integer)
ABS	Returns the absolute value of a number
MOD	Returns the remainder from division
POWER	Returns the result of a number raised to a power
SQRT	Returns a positive square root
In Excel 2007 and Up
SUMIFS	Adds the cells specified by one or many given criteria (SUMPRODUCT does better)

In the downloadable tutorial on Excel functions and formulas you will find example of formulas using each of these functions and even many of them assembled in easy and powerful formulas.

Go to the next lesson:
Lesson 9: Excel Statistical Functions

See the complete version of this lesson in
The Tutorial on Excel
Functions