- Basic Rounding with ROUND()
- Rounding in a Specific Direction with ROUNDUP() and ROUNDDOWN()
- More Control Over Rounding with FLOOR() and CEILING()
- Getting Rid of Decimals with INT() and TRUNC()
Like this article? We recommend
Like this article? We recommend
Like this article? We recommend
Rounding in a Specific Direction with ROUNDUP() and ROUNDDOWN()
If you want to round up or round down regardless of the value, use the ROUNDUP() function or the ROUNDDOWN() function, respectively. These functions don’t care whether the next decimal is above or below five—they always go either up or down. As when using ROUND(), you specify the number of decimal places. For example:
- =ROUNDUP(1.11111, 2) returns 1.12.
- =ROUNDUP(1.88888, 2) returns 1.89.
- =ROUNDDOWN(1.11111, 2) returns 1.11.
- =ROUNDDOWN(1.88888, 2) returns 1.88.
It’s important to note that ROUNDUP() and ROUNDDOWN() don’t work the way you might expect with negative values. Strictly speaking, "up" should mean "to the nearest greater value" or, with negative numbers, less negative. Likewise, "down" should mean "to the nearest lesser value" or, with negative numbers, more negative. But the functions don’t work that way. ROUNDUP() rounds negative values away from zero and ROUNDDOWN() rounds them toward zero. For example:
- =ROUNDUP(-1234.56, -2) evaluates to -1300.
- =ROUNDDOWN(-1234.56, -2) evaluates to -1200.
As explained in the previous section on the ROUND() function, you can also pass negative values for the number of decimal places to round the value to the left of the decimal point, as shown in the previous examples.