A function in Excel is a preset formula, that helps perform mathematical, statistical, and logical operations. Worksheet functions are categorized by their functionality.

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