ROUNDUP and ROUNDDOWN in Google Sheets
Force numbers up or down to a set number of decimals: ROUNDUP always rounds away from zero, ROUNDDOWN always toward zero.
=ROUNDUP(A2, 2)
Rounds A2 up to 2 decimal places. Use ROUNDDOWN to round down, or ROUND for normal rounding.
How it works
ROUNDUP and ROUNDDOWN take a number and the number of decimal places to keep. ROUNDUP always pushes the value away from zero (2.001 becomes 2.01), while ROUNDDOWN always pulls it toward zero (2.999 becomes 2.99), no matter what the next digit is. Use 0 places to round to whole numbers, or a negative number of places to round to tens, hundreds and so on.
Variations
Round down to a whole number
=ROUNDDOWN(A2, 0)
Chops off the decimals — 7.99 becomes 7.
Round up to the nearest 10
=ROUNDUP(A2, -1)
A negative place value rounds to the left of the decimal point.
Normal (nearest) rounding
=ROUND(A2, 2)
Rounds up or down depending on the next digit.
Examples
| Scenario | Formula |
|---|---|
| Always round a price up to the cent | =ROUNDUP(A2, 2) |
| Round a total down to whole dollars | =ROUNDDOWN(A2, 0) |
FAQ
What is the difference between ROUND, ROUNDUP and ROUNDDOWN?
ROUND rounds to the nearest value, ROUNDUP always rounds away from zero, and ROUNDDOWN always rounds toward zero.
How is ROUNDDOWN different from INT?
For positive numbers they match, but INT always rounds toward negative infinity, so INT(-2.5) is -3 while ROUNDDOWN(-2.5,0) is -2.
How do I round to the nearest 5 or 25?
Use MROUND, e.g. =MROUND(A2,5) rounds to the nearest multiple of 5.
Related formulas
- Google Sheets Formulas Cheat Sheet — 34 Copy-Paste Formulas
- How to Calculate Percentage of a Total in Google Sheets
- How to Combine Two Columns in Google Sheets
- How to Count Cells With Text in Google Sheets
- How to Count Unique Values in Google Sheets
- How to Remove Duplicates in Google Sheets
- How to Remove Extra Spaces in Google Sheets
- How to Split Text Into Columns in Google Sheets