Excel Formulas

Math Excel Formula Examples

Copy-paste examples for math formulas in Excel.

💡 Ideas for You

Helpful resources matched to this page.

4 focused options
📚 Step-by-step booksIndependent learning resources and step-by-step books from Create & Learn.📘 Topic guideAmazon ideas related to Math.🧮 Formula booksBooks and references for spreadsheet formulas and examples.⌨️ Productivity setupHelpful books, office tools, and productivity resources.

Browse formulas

Choose a formula page for copy-paste examples, step-by-step notes, and common mistakes.

fx

SUM Formula

Add numbers together.

fx

SUMIF Formula

Add values that meet one condition.

fx

SUMIFS Formula

Add values that meet multiple conditions.

fx

SUBTOTAL Formula

Calculate totals that can ignore filtered-out rows.

fx

AGGREGATE Formula

Calculate totals while ignoring hidden rows or errors.

fx

PRODUCT Formula

Multiply values together.

fx

SUMPRODUCT Formula

Multiply arrays and add the results.

fx

ROUND Formula

Round a number to a selected number of decimals.

fx

ROUNDUP Formula

Round a number up.

fx

ROUNDDOWN Formula

Round a number down.

fx

MROUND Formula

Round a number to a multiple.

fx

CEILING Formula

Round a number up to the nearest multiple.

fx

FLOOR Formula

Round a number down to the nearest multiple.

fx

ABS Formula

Return the absolute value of a number.

fx

MOD Formula

Return the remainder after division.

fx

QUOTIENT Formula

Return the integer part of a division.

fx

RAND Formula

Return a random decimal number.

fx

RANDBETWEEN Formula

Return a random integer in a range.

fx

SEQUENCE Formula

Generate a sequence of numbers.