## Functions

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