Math functions Excel Formulas Cheat Sheet
|
=SUM |
Add the total of a series of numbers.
|
|
=AVERAGE |
Calculates the average of a series of numbers.
|
|
=MEDIAN |
Returns the median average number of a series.
|
|
=SUMPRODUCT |
Calculates the weighted average, very useful for financial analysis.
|
|
=PRODUCT |
Multiplies all of a series of numbers.
|
|
=ROUNDDOWN |
Rounds a number to the specified number of digits. =ROUNDDOWN(number,num_digits)
|
|
=ROUNDUP |
The formula rounds a number to the specific number of digits.
|
|
=ABS |
Returns the absolute value of a number. Negative numbers are converted to positive numbers and positive numbers stay the same.
|
|
=PI |
Returns the value of pi, accurate to 15 digits.
|
|
=SUMIF |
Sum values in a range that are specified by a condition.
|
See also:
Free Training Course: Lesson 1 - Excel Fundamentals
See also: Index to Excel VBA Code; Index to Excel Freebies; Lesson 1 - Excel Fundamentals; Index to how to… providing a range of solutions
Microsoft ® and Microsoft Excel ® are registered trademarks of Microsoft Corporation. OzGrid is in no way associated with Microsoft.
Click here to visit our Free 24/7 Excel/VBA Help Forum where there are thousands of posts you can get information from, or you can join the Forum and post your own questions.
Gallery
