Math functions excel formulae sheet

< Back to Search results

 Category: [Excel]  Demo Available 

Math functions Excel Formulas Cheat Sheet



Add the total of a series of numbers.


Calculates the average of a series of numbers.


Returns the median average number of a series.


Calculates the weighted average, very useful for financial analysis.


Multiplies all of a series of numbers.




Rounds a number to the specified number of digits.



The formula rounds a number to the specific number of digits.


Returns the absolute value of a number. Negative numbers are converted to positive numbers and positive numbers stay the same.


Returns the value of pi, accurate to 15 digits.


Sum values in a range that are specified by a condition.


See also:

Dates and time Excel formulas reference sheet
Conditional Functions Reference Sheet
Excel different types of data reference sheet
Useful formulae reference sheet
Financial formulae reference sheet
Index and match reference sheet
Lookup formulae reference sheet
Maths functions excel formulae sheet


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.



stars (0 Reviews)