# Excel math functions

> Math functions add, multiply and round numbers. SUM handles most totals.

Source: https://spreadsheetpractice.com/functions/category/math · Updated October 29, 2026

Math functions add, multiply and round numbers. SUM handles most totals. The rounding family (ROUND, ROUNDUP, ROUNDDOWN, MROUND, CEILING and FLOOR) decides how numbers are cut to size for prices, quantities and time. SUMPRODUCT turns two columns, such as units and price, into one total without a helper column.

## Which one to use

| You want to | Use | Why |
|---|---|---|
| Add up a column or block of numbers | [SUM](https://spreadsheetpractice.com/functions/sum) | Skips text and blanks, so a header inside the range does no harm. |
| Total units × price without a helper column | [SUMPRODUCT](https://spreadsheetpractice.com/functions/sumproduct) | Multiplies row by row, then adds the results. |
| Round money to cents for an invoice | [ROUND](https://spreadsheetpractice.com/functions/round) | Changes the stored value, not just what the cell displays. |
| Always round up: boxes, packs, staff | [ROUNDUP](https://spreadsheetpractice.com/functions/roundup) | Never leaves you one short. |
| Round to the nearest 5, 15 or 0.25 | [MROUND](https://spreadsheetpractice.com/functions/mround) | Rounds to any multiple, up or down, whichever is closer. |
| Find leftovers, odd and even, or every Nth row | [MOD](https://spreadsheetpractice.com/functions/mod) | Returns the remainder after division. |

## All 25 math functions

| Function | What it does | Available in |
|---|---|---|
| [ABS](https://spreadsheetpractice.com/functions/abs) | ABS returns a number without its sign, so -250 becomes 250 and 250 stays 250. | Every current version |
| [AGGREGATE](https://spreadsheetpractice.com/functions/aggregate) | AGGREGATE runs one of 19 calculations, from SUM and AVERAGE to LARGE and PERCENTILE, and can skip error values, hidden rows and other subtotals while it does. | Excel 2010 and later |
| [CEILING](https://spreadsheetpractice.com/functions/ceiling) | CEILING rounds a number up to the next multiple you choose: the next 5, the next dozen, the next quarter hour. | Every current version |
| [EXP](https://spreadsheetpractice.com/functions/exp) | EXP returns e (about 2.71828) raised to a power. | Every current version |
| [FLOOR](https://spreadsheetpractice.com/functions/floor) | FLOOR rounds a number down to the previous multiple you choose: down to the nearest 10, the nearest quarter, or the start of a price band. | Every current version |
| [INT](https://spreadsheetpractice.com/functions/int) | INT rounds a number down to the nearest whole number. | Every current version |
| [LN](https://spreadsheetpractice.com/functions/ln) | LN returns the natural logarithm of a number: the power you would raise e to in order to get it. | Every current version |
| [LOG](https://spreadsheetpractice.com/functions/log) | LOG returns the logarithm of a number in the base you choose: the power the base must be raised to in order to reach the number. | Every current version |
| [LOG10](https://spreadsheetpractice.com/functions/log10) | LOG10 returns the base-10 logarithm of a number: how many times 10 is multiplied to reach it. | Every current version |
| [MOD](https://spreadsheetpractice.com/functions/mod) | MOD returns the remainder after dividing one number by another. | Every current version |
| [MROUND](https://spreadsheetpractice.com/functions/mround) | MROUND rounds a number to the nearest multiple of another number. | Every current version |
| [PI](https://spreadsheetpractice.com/functions/pi) | PI returns the constant π, accurate to 15 digits (3.14159265358979). | Every current version |
| [POWER](https://spreadsheetpractice.com/functions/power) | POWER raises a number to a power, the same as the ^ operator. | Every current version |
| [PRODUCT](https://spreadsheetpractice.com/functions/product) | PRODUCT multiplies all of its arguments together. | Every current version |
| [QUOTIENT](https://spreadsheetpractice.com/functions/quotient) | QUOTIENT divides one number by another and returns only the whole-number part, dropping the remainder. | Every current version |
| [ROUND](https://spreadsheetpractice.com/functions/round) | ROUND rounds a number to the number of digits you choose. | Every current version |
| [ROUNDDOWN](https://spreadsheetpractice.com/functions/rounddown) | ROUNDDOWN always rounds toward zero, dropping the extra digits whatever they are. | Every current version |
| [ROUNDUP](https://spreadsheetpractice.com/functions/roundup) | ROUNDUP always rounds away from zero, whatever the next digit is. | Every current version |
| [SIGN](https://spreadsheetpractice.com/functions/sign) | SIGN tells you which side of zero a number is on: 1 for positive, -1 for negative and 0 for zero. | Every current version |
| [SQRT](https://spreadsheetpractice.com/functions/sqrt) | SQRT returns the square root of a number: the value that, multiplied by itself, gives the number. | Every current version |
| [SUBTOTAL](https://spreadsheetpractice.com/functions/subtotal) | SUBTOTAL calculates a sum, average, count or other total for a range while skipping any other SUBTOTAL formulas inside it, so section subtotals and a grand total never double count. | Every current version |
| [SUM](https://spreadsheetpractice.com/functions/sum) | SUM adds numbers. | Every current version |
| [SUMPRODUCT](https://spreadsheetpractice.com/functions/sumproduct) | SUMPRODUCT multiplies matching items in two or more ranges and adds the results. | Every current version |
| [SUMSQ](https://spreadsheetpractice.com/functions/sumsq) | SUMSQ squares each number and adds the squares. | Every current version |
| [TRUNC](https://spreadsheetpractice.com/functions/trunc) | TRUNC cuts a number off at a set number of decimals without rounding. | Every current version |

## Comparisons

- [ROUND vs ROUNDUP vs ROUNDDOWN](https://spreadsheetpractice.com/functions/compare/round-vs-roundup-vs-rounddown): ROUND goes to the nearest value. ROUNDUP always moves away from zero and ROUNDDOWN always moves toward it, whatever the next digit is.

---

Spreadsheet Practice (https://spreadsheetpractice.com) teaches spreadsheet formulas by practice: every exercise is graded in a live grid and re-checked on changed data.
