Math Finctions
The Excel Math Functions perform many of the common mathematical calculations, including basic arithmetic, conditional sums & products, exponents & logarithms, and the trigonometric ratios. The tables below list most common math functions you need to solve day to day business problems. Selecting a "Example" link will take you to a full description of the function, with examples of use and common errors.
| Functions |
Syntax |
Tutorial |
| SUM Function |
SUM(number1, [number2],…) |
Example |
| SUMIF Function |
SUMIF(range, criteria, sum_range) |
Example |
| SUMIFS Function |
SUMIFS(sum_range, criteria1, criteria1 range,….) |
Example |
| SUBTOTAL |
SUBTOTAL(function_num,REH1) |
Example |
| ROUND Function |
ROUND(number, num_digits) |
Example |
| ROUNDUP Function |
ROUNDUP(number, num_digits) |
Example |
| ROUNDDOWN Function |
ROUNDDOWN(number, num_digits) |
Example |
| FLOOR Function |
FLOOR(number, significance) |
Example |
| CEILING Function |
CEILING(number, significance) |
Example |
| RANDBETWEEN Function |
RANDBETWEEN(bottom, top) |
Example |