A to Z of Excel Functions: The ROUNDUP Function

Welcome back to our regular A to Z of Excel Functions blog.  Today we look at the ROUNDUP function.

The ROUNDUP function

The ROUNDUP function rounds a number up to a specified number of digits, away from zero [0].  It employs the following syntax to operate:

The ROUNDUP function has the following arguments:

• number: this is required and represents the value to be rounded
• num_digits: also required, this is the number of digits to which you wish to round the number.

It should be further noted that:

• ROUNDUP behaves like ROUND, except that it always rounds a number up, away from zero [0]
• ROUNDUP rounds up, away from zero.  For example, ROUNDUP(3.5,0) equals 4, but ROUNDUP(-3.5,0) equals -4, not -3 (see image, below)

• the number can be a number, a cell reference or a named range
• this function operates on the actual value in the cell and rounds it so it is consistent with the value that is displayed
• using this function will change the underlying value and not just the value that is displayed
• you can use the ROUND function if you always want the number rounded to a specified number of digits
• you can use the ROUNDUP function if you always want the number rounded up to the nearest integer
• you can use the FLOOR.MATH function to round down to the nearest integer or significant figure
• you can use the CEILING.MATH function to round up to the nearest integer or significant figure
• you can use the MROUND function to round to a desired multiple
• you can use the EVEN function to round up to the nearest even integer
• you can use the ODD function to round up to the nearest odd integer
• the equivalent VBA function is VBA.ROUND.

Please see my examples below:

We’ll continue our A to Z of Excel Functions soon.  Keep checking back – there’s a new blog post every other business day.