In Excel: use =ROUND(A2, 2) to round to 2 decimal places, ROUNDUP or ROUNDDOWN to force the direction, or MROUND for the nearest multiple; Home ▸ Decrease Decimal only changes the display, not the stored value.
On this page7
Click an empty cell and type =ROUND(A2, 2), replacing 2 with the decimal places you need.
Use 0 to round to whole numbers, or negative digits for tens and hundreds: =ROUND(A2, -2) turns 1234 into 1200.
Switch to ROUNDUP or ROUNDDOWN when the direction must not depend on the decimals.
Use =MROUND(A2, 5) to reach the nearest multiple — 0.05 for 5-cent pricing.
Reserve Home ▸ Decrease Decimal for pure display changes; it never alters the value.
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. The difference between a quick fix and a sheet you can trust is the extra minute you spend validating “excel formula for rounding off”. Start on a copy or a tiny sample, keep the affected formula visible, and compare the result with the outcome you expected before you touch the real workbook. 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. The point is a calculation you can defend to a CFO or an auditor, but the practical win is that someone else can open the file and understand what happened without asking you.
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. Check the referenced cells, argument order and result type in your workbook. Start with the worked example before changing an input, then compare the changed result with the calculation you expected. An error value or a result of a different type is a reason to inspect the inputs and arguments.
In Google Sheets
Google Sheets support for this task has not been verified. Check the function, arguments and workflow in the target product before transferring the example. Matching formula notation does not establish identical behaviour. The aim was to get you unstuck fast and leave you a little more capable than a copy-paste would. The answer is at the top and the detail above shows why it holds — so the next time a colleague asks, you can answer without reaching for search. For “excel formula for rounding off”, keep the input cells and the result visible while you check the formula in Excel. Follow the worked example and change one input at a time. The steps explain the workbook calculation; this page does not run a live calculator for that task.
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) withROUNDUPandROUNDDOWN(forced direction). - Forgetting that
MROUNDreturns#NUM!when the number and the multiple have opposite signs. - Rounding intermediate results, which compounds errors down a calculation chain.
Frequently asked questions
How do I round to 2 decimal places in Excel?
Use =ROUND(A2, 2). To only shorten the display, use Home ▸ Decrease Decimal instead.
How do I round to the nearest whole number?
=ROUND(A2, 0). Use ROUNDUP or ROUNDDOWN when the result must always go one way.
Why don’t my totals add up after rounding?
You rounded the display, not the values. Wrap each figure in ROUND so the stored numbers match what is printed.