Mathematical Functions

The Mathematical Functions are used in Excel to perform various arithmetic operations such as addition, subtraction, division and the product of two numbers. They are also used to generate random values, or to round values and to calculate all kinds of subtotals. Here are some of the most commonly used Mathematical Functions:

MOD - Returns the remainder (residue) of the division of two numbers.

MROUND - Rounds a number to the nearest multiple.

RAND- Returns a random number. The number is always greater than (or equal to) zero but less than one.

RANDBETWEEN - Returns a random number between two specified numbers.

ROUND - Rounds a number to the specified number of decimal places.

ROUNDUP - Rounds up a number to the number of decimal places specified.

ROUNDDOWN - Rounds down a number to the number of decimal places specified.

SUBTOTAL - Returns a subtotal in a list or database.

SUM - Returns the sum of a range of cells.

SUMIF - Add the cells specified by a given condition or criteria.

SUMIFS - Add the cells specified by a given set of conditions or criterias.

SUMPRODUCT - Multiplies two or more arrays and returns the sum of the products.