Written and reviewed by FormulaCraft Team. Each formula on this page is run through our verification engine before publishing.
Last reviewed:
ROUND vs ROUNDUP vs ROUNDDOWN in Excel and Sheets
Excel & Google Sheets
=ROUND(A2,2)✓
Verified example
Computed by a real spreadsheet engine on the sample data below.
| Value | Rounded |
| 3.456 | 3.46 |
| 7.891 | 7.89 |
| 2.345 | 2.35 |
| 9.999 | 10.00 |
| 1.001 | 1.00 |
=ROUND(A2,2)→3.46
Try it with your data
Edit the grid or formula, then run it through a real spreadsheet engine — no signup.
Sample data — click any cell to edit
Runs server-side · free · no signup
Step by step
- 1Choose the function based on your rounding rule: ROUND for standard, ROUNDUP when you must never undercount (e.g., ceiling prices), ROUNDDOWN when you must never overcount (e.g., floor inventory).
- 2Write =ROUND(number, num_digits) — positive num_digits rounds to decimal places, 0 rounds to a whole number, negative rounds to tens/hundreds.
- 3For ROUNDUP or ROUNDDOWN, use the same syntax: =ROUNDUP(A2, 2) or =ROUNDDOWN(A2, 2).
- 4To round to the nearest 0.05, combine with division: =ROUND(A2/0.05,0)*0.05.
Tips
- Use ROUNDUP for taxes and fees where under-rounding could cause compliance issues, and ROUNDDOWN for inventory where partial units cannot be shipped.
Need it for your exact data?
Describe your columns in plain English and get the precise formula for your sheet, with the right Excel or Sheets syntax.
Frequently asked
How do I round to the nearest 10?
Use a negative num_digits: =ROUND(A2,-1) rounds to the nearest 10, =ROUND(A2,-2) to the nearest 100.
What is the difference between ROUNDDOWN and INT?
INT always rounds toward negative infinity; ROUNDDOWN always rounds toward zero. They differ for negative numbers: INT(-2.7) = -3, ROUNDDOWN(-2.7,0) = -2.