Home > Articles > Home & Office Computing > Microsoft Applications

  • Print
  • + Share This
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.

  • + Share This
  • 🔖 Save To Your Account