# OzGrid

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.

Free Training Course: Lesson 1 - Excel Fundamentals

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

stars (0 Reviews)