How to Use ROUND, ROUNDUP, and ROUNDDOWN in Excel
ROUND, ROUNDUP, and ROUNDDOWN control decimal precision in Excel. Use them for pricing, budgets, forecasts, and clean reporting.
Reviewed by Griddy
Updated for current Excel and Google Sheets workflows, with examples chosen to map back to real spreadsheet tasks rather than abstract formula syntax.
ROUND, ROUNDUP, and ROUNDDOWN control how many decimal places a number should keep. Use them when pricing, budgets, forecasts, percentages, or reports need clean numbers instead of long decimals.
The key difference is direction: ROUND goes to the nearest value, ROUNDUP always moves away from zero, and ROUNDDOWN always moves toward zero.
The syntax
=ROUND(number, num_digits)=ROUNDUP(number, num_digits)=ROUNDDOWN(number, num_digits)- number - the value to round
- num_digits - how many digits to keep
Use 2 for cents, 0 for whole numbers, and negative values to round to tens, hundreds, or thousands.
=ROUND(125.487, 2)returns 125.49.
=ROUND(125.487, 0)returns 125.
=ROUND(125.487, -1)returns 130.
Example: clean a budget forecast
Suppose a forecast calculates monthly software cost after growth assumptions. The raw result in D2 is:
1847.6382
For a management budget, whole dollars are easier to read.
Step 1. Round to the nearest dollar
=ROUND(D2, 0)The result is 1848.
Step 2. Round up when you want a conservative cost estimate
=ROUNDUP(D2, 0)This also returns 1848, but the intent is different. ROUNDUP always moves costs upward, which is often the safer planning assumption.
Step 3. Round down when you want a conservative revenue estimate
=ROUNDDOWN(D2, 0)This returns 1847.
✦ TIP
Rounding vs formatting
Cell formatting only changes what you see. The underlying value can still contain extra decimals.
Rounding changes the actual value returned by the formula.
That difference matters when rounded values feed other formulas. If exact math matters, keep detailed values in helper columns and round only the final reporting output.
Common issues
| Issue | Cause | Fix |
|---|---|---|
| Totals do not match visible rows | Cells are formatted, not rounded | Use ROUND in the formulas that feed the report |
| Cents disappear | num_digits is 0 | Use 2 for currency cents |
| Unexpected tens or hundreds | num_digits is negative | Use positive digits for decimals |
| Forecast is too optimistic | Revenue is rounded up | Consider ROUNDDOWN for revenue assumptions |
The Griddy way
Rounding rules get messy fast when one sheet mixes revenue, costs, margins, and percentages.
"Round costs up to whole dollars, round revenue down to whole dollars, and keep margin percentages to one decimal place"
Griddy can apply the right rounding formulas across the model while leaving the underlying structure readable.
Skip the manual work
Describe it. Griddy does it.
Instead of writing this formula yourself, just tell Griddy what you need in plain English. Works in Excel and Google Sheets.
Use this on real templates
Apply rounding rules to real budgets
Rounding matters in operating plans where costs, revenue, and margin should be presented cleanly without hiding the underlying math.
Small Business Budget
Plan revenue, direct costs, overhead, and EBITDA in one compact operating budget. Keep H1 totals, margin, and owner notes visible without building a giant finance model.
Small Business Budget for Restaurants
Plan restaurant sales, food costs, labor, rent, supplies, delivery fees, and operating margin in one free budget spreadsheet template.
Small Business Budget for Retail
Plan retail revenue, inventory costs, payroll, rent, marketing, software, and operating margin with a free budget spreadsheet template.
Budget Tracker
Track income, expenses, and savings in one place. Line items, budgeted vs actual totals, and monthly net savings — free to use in your browser.