What this category helps you do
Math formulas are the base of most spreadsheets. They help you total numbers, round values for reports, handle remainders, generate random values, and summarize rows without manual calculation.
- Add sales by row or category
- Round prices to clean values
- Build a running total
- Calculate discounts and adjustments
Math formula examples
Choose a formula below. Each page explains the formula in plain English and gives examples one at a time so long formulas are easier to read and copy.
ABS
returns the positive version of a number.
Open examples →FormulaAGGREGATE
summarizes data while optionally ignoring errors, hidden rows, or subtotals.
Open examples →FormulaCEILING
rounds a number up to the nearest multiple.
Open examples →FormulaFLOOR
rounds a number down to the nearest multiple.
Open examples →FormulaMOD
returns the remainder after division.
Open examples →FormulaMoving Average
averages the latest set of values in a rolling window.
Open examples →FormulaMROUND
rounds a number to the nearest multiple.
Open examples →FormulaPRODUCT
multiplies numbers together.
Open examples →FormulaQUOTIENT
returns the integer part of a division.
Open examples →FormulaRAND
returns a random decimal between 0 and 1.
Open examples →FormulaRANDBETWEEN
returns a random whole number between two limits.
Open examples →FormulaROUND
rounds a number to a set number of digits.
Open examples →FormulaROUNDDOWN
rounds a number down, toward zero.
Open examples →FormulaROUNDUP
rounds a number up, away from zero.
Open examples →FormulaRunning Total
calculates a cumulative total down a column.
Open examples →FormulaSEQUENCE
creates a dynamic list of sequential numbers.
Open examples →FormulaSUBTOTAL
calculates a subtotal that can ignore filtered rows.
Open examples →FormulaSUM
adds numbers together.
Open examples →FormulaSUMIF
adds values that meet one condition.
Open examples →FormulaSUMIFS
adds values that meet multiple conditions.
Open examples →FormulaSUMPRODUCT
multiplies matching items in arrays and returns the sum.
Open examples →Best formulas to start with
How to learn this category
- Open one formula page and test the first beginner example.
- Change one cell reference at a time so you understand what each part controls.
- Check the common mistakes section before copying the formula down.
- Move to related formulas when you need a cleaner or more advanced version.