Complete guide to all Excel rounding methods and functions
Excel offers 7 main functions for rounding numbers, each with specific use cases. This guide covers all methods with practical examples.
Standard mathematical rounding
=ROUND(12.5, 0) → 13
Always rounds up
=ROUNDUP(12.1, 0) → 13
Always rounds down
=ROUNDDOWN(12.9, 0) → 12
Round to nearest multiple
=MROUND(13, 5) → 15
Round up to multiple
=CEILING(12, 5) → 15
Round down to multiple
=FLOOR(13, 5) → 10
Remove decimals entirely
=INT(12.9) → 12
=ROUND(number, num_digits)
Follows 5+ up, <5 down rule
| Formula | Result | Explanation |
|---|---|---|
| =ROUND(12.567, 2) | 12.57 | 2 decimals |
| =ROUND(12.567, 1) | 12.6 | 1 decimal |
| =ROUND(12.567, 0) | 13 | Whole number |
| =ROUND(1234, -2) | 1200 | To hundreds |
Always rounds away from zero
=ROUNDUP(3.1, 0) → 4
=ROUNDUP(3.9, 0) → 4
Always rounds toward zero
=ROUNDDOWN(3.1, 0) → 3
=ROUNDDOWN(3.9, 0) → 3
Syntax: =CEILING(number, significance)
=CEILING(23, 5) → 25 (next multiple of 5)
=CEILING(12, 10) → 20 (next multiple of 10)
=CEILING(234, 100) → 300 (next multiple of 100)
Syntax: =FLOOR(number, significance)
=FLOOR(23, 5) → 20 (previous multiple of 5)
=FLOOR(18, 10) → 10 (previous multiple of 10)
=FLOOR(267, 100) → 200 (previous multiple of 100)
MROUND rounds to the nearest multiple using standard rounding rules (5+ goes up).
Syntax: =MROUND(number, multiple)
=MROUND(23, 5) → 25 (23 is closer to 25 than 20)
=MROUND(22, 5) → 20 (22 is closer to 20 than 25)
=MROUND(13, 10) → 10 (nearest 10)
=MROUND(18, 10) → 20 (nearest 10)
Returns integer part (rounds down)
=INT(12.3) → 12
=INT(12.9) → 12
=INT(99.99) → 99
Truncates to specified decimal
=TRUNC(12.567, 2) → 12.56
=TRUNC(12.567, 1) → 12.5
=TRUNC(12.567) → 12
Use ROUND(number, decimals)
Use ROUNDUP(number, decimals)
Use ROUNDDOWN(number, decimals)
Use MROUND(number, multiple)
Use INT(number)
| Value | ROUND | ROUNDUP | ROUNDDOWN | INT |
|---|---|---|---|---|
| 3.2 | 3 | 4 | 3 | 3 |
| 3.5 | 4 | 4 | 3 | 3 |
| 3.9 | 4 | 4 | 3 | 3 |