ROUND Formula Generator
Describe how you need a number rounded in plain English and get a ready-to-use ROUND, ROUNDUP, or ROUNDDOWN formula for Excel or Google Sheets.
5 free tries without an account
ROUND, ROUNDUP, and ROUNDDOWN syntax
=ROUND(number, num_digits)
=ROUNDUP(number, num_digits)
=ROUNDDOWN(number, num_digits)number is the value to round, and num_digits is how many decimal places to keep — use 0 for a whole number, or a negative number to round to tens, hundreds, or thousands. Formulon picks the right variant for whether you need standard rounding or a guaranteed round-up/round-down.
Examples
Round a price to 2 decimal places
=ROUND(A2,2)Rounds the value in A2 to the nearest cent — e.g. 19.995 becomes 20.00, and the rounded value is what other formulas will actually calculate with.
Always round up to the nearest whole number
=ROUNDUP(A2,0)Rounds the value in A2 up to the next whole number no matter how small the decimal is — e.g. 4.01 becomes 5, useful for things like billing units or box quantities where partial units still need a full one.
Frequently asked questions
What's the difference between ROUND, ROUNDUP, and ROUNDDOWN?
ROUND rounds to the nearest value using standard rounding rules (0.5 rounds up). ROUNDUP always rounds away from zero, and ROUNDDOWN always rounds toward zero, regardless of the digit that follows — useful when you need to guarantee a value is never understated or never overstated.
How do I round to the nearest ten, hundred, or thousand?
Use a negative num_digits: =ROUND(A2,-2) rounds to the nearest hundred, =ROUND(A2,-3) to the nearest thousand. Positive num_digits rounds to that many decimal places instead.
Does rounding the display format change the actual value?
No — changing a cell's number format (e.g. showing 2 decimal places) only changes what's displayed; the full underlying value is still used in later calculations. ROUND actually changes the stored value, which matters if other formulas reference that cell.
Is ROUND the same in Google Sheets?
Yes, ROUND, ROUNDUP, and ROUNDDOWN all have identical syntax and behavior in Excel and Google Sheets. Both also support MROUND for rounding to a custom multiple.
Don't want to write it by hand?
Describe what you need in plain English and get a ready-to-use formula in seconds.
Try the formula generator