Guides / Excel

Excel Guide

SUM, ROUND & Excel's Core Math Functions

Adding a range of cells and rounding a result are two of the most common things you'll do in Excel — and the ones most likely to go subtly wrong if you don't know the details.

SUM: adding a range

Instead of writing =A1+A2+A3, which breaks the moment you add a fourth row, use SUM with a range reference:

=SUM(A1:A3)

SUM scales automatically — extend the range and it keeps working. It also ignores text and empty cells inside the range, so it's safe to use even if a column has the occasional label mixed in.

ROUND, ROUNDUP, ROUNDDOWN

ROUND takes a number and how many decimal places to keep:

=ROUND(4.567, 2) // 4.57 — rounds to nearest =ROUNDUP(4.561, 2) // 4.57 — always rounds up =ROUNDDOWN(4.569, 2) // 4.56 — always rounds down

The difference matters most in billing and inventory contexts: ROUNDUP is the safe choice when under-charging or under-ordering isn't an option (e.g. how many boxes you need to ship a quantity of items), while plain ROUND is right for things like displaying a price to two decimal places.

Common mistake: using a number format (like "2 decimal places") to control how a value looks, then being surprised when Excel still calculates with the full unrounded number underneath. Formatting changes the display; ROUND changes the actual value.

ABS and MOD

ABS strips the sign off a number — useful when you care about the size of a difference, not its direction:

=ABS(A1-A2) // always positive, regardless of which is bigger

MOD returns the remainder after division — handy for anything that repeats in a cycle, like assigning every 3rd row a different color, or checking if a number is even:

=MOD(10, 3) // 1 =MOD(A1, 2) // 0 if A1 is even, 1 if odd

Try it yourself

Practice SUM, ROUND, and the rest of Excel's math functions with real interactive exercises and instant feedback.

Start practicing math formulas →

Related guides