Excel Rounding Formulas

What this does

ROUND changes the stored value to the nearest number at the digits you specify, rounding .5 away from zero. ROUNDUP and ROUNDDOWN force the direction regardless of the next digit, and MROUND rounds to the nearest multiple, such as 5 or 0.05. That is different from Home ▸ Decrease Decimal, which only shortens the display: the cell keeps its full value, which is why formatted sheets can show totals that don’t add up. The same functions work in Google Sheets. Most people learn this as a sequence of clicks and forget it by next week; learning it as a pattern instead is what lets you apply it to the next, slightly different version of the problem without starting from scratch. That is the difference this page is trying to make. For “excel rounding formulas”, the reliable version is a short checking loop, not just the first command that appears to work. Run it on a deliberately small range first, watch how the affected formula change, and only then apply the same setup to the full sheet. When a formula is involved, keep the inputs labelled beside it, reference cells instead of typing values, and apply number formatting only after the result checks out. That is what makes a calculation you can defend to a CFO or an auditor useful in real work: repeatable, auditable, and not dependent on memory or luck.

A worked example

A2 contains 3.14159. =ROUND(A2, 2) returns 3.14 and =ROUNDUP(A2, 2) returns 3.15. For multiples, =MROUND(47, 5) returns 50, and =MROUND(4.87, 0.05) returns 4.85 — the classic nearest-5-cents price. Rounding matters wherever printed figures must reconcile — invoices, price lists, reports — because a sum over full-precision values rarely matches a column of neatly formatted numbers. One habit worth forming early: name the cells that hold your inputs, so the formula reads in plain language instead of a string of cell addresses. A reviewer — or you in three months — can then follow the logic without decoding what B7 and D2 were supposed to mean, which is most of what makes a sheet maintainable.

In Google Sheets

Everything above works in Google Sheets too. Excel and Sheets share the formula syntax used here; only the surrounding menus are arranged differently. That portability is deliberate — learn it once and it follows you between the two tools and across Windows and Mac. Nothing on this page is behind a login: the tool runs entirely in your browser, the formula is shown in full with one-click copy, and the steps work the same on Windows and Mac. That is the whole promise here — the exact answer, a way to prove it on your own numbers, and just enough context to make it stick. If you take one thing from this page on “excel rounding formulas”, make it the habit rather than the keystrokes: set the problem up with labelled inputs, reference those cells, and let Excel do the recomputing. Bookmark the page for the syntax, but do the example once in a blank sheet and check it against the tool above — five minutes of hands-on practice fixes the method in memory far better than re-reading, and it surfaces the small snags while they are still harmless. After that the technique is genuinely yours: faster than searching for it again, and reliable enough to drop into work that other people depend on.

Common mistakes

• Using Decrease Decimal and expecting the stored value to change — the cell still holds 3.14159.
• Wondering why totals don’t match the visible digits: the sum uses full precision, the display doesn’t.
• Confusing ROUND (to nearest) with ROUNDUP and ROUNDDOWN (forced direction).
• Forgetting that MROUND returns #NUM! when the number and the multiple have opposite signs.
• Rounding intermediate results, which compounds errors down a calculation chain.

Frequently asked questions