ROUND Formula Generator
Three rounding functions: ROUND (nearest), ROUNDUP (always up), ROUNDDOWN (always down / truncate). All take a number and digit count.
Syntax
=ROUND(number, num_digits) / =ROUNDUP(number, num_digits) / =ROUNDDOWN(number, num_digits)Try it — generate a ROUND / ROUNDUP / ROUNDDOWN formula
Examples
Round to 2 decimals (money)
=ROUND(A2, 2)$12.3456 → $12.35.
Round up to nearest whole
=ROUNDUP(A2, 0)12.1 → 13. Ceiling-style rounding.
Round down to nearest 100
=ROUNDDOWN(A2, -2)Negative digits round to tens, hundreds, thousands. 1256 → 1200.
Tips
- ✓Negative num_digits rounds left of the decimal (tens, hundreds, thousands).
- ✓0 rounds to whole numbers. 2 rounds to cents.
- ✓Formatting a cell to show 2 decimals is not the same as rounding — the underlying value still has full precision.
Related Formulas
Nested IF
Nested IF formulas let you test multiple conditions and return different values ...
SUMIFS
SUMIFS adds up values that meet multiple criteria. It's essential for financial ...
AVERAGEIFS
AVERAGEIFS calculates the average of cells that meet multiple criteria. Useful f...
Need a different formula?
Describe any formula in plain English and FormulaPad will generate it.
Try FormulaPad Free