ROUNDUP function is used to return a number after it is rounded up to the specified decimal places. The function rounds up every number between 1 and 9. This is unlike the standard rounding in mathematics where you round down numbers less than 5 and round up any number between 5 and 9.

## The general formula

`=ROUNDUP(number, num_digits)`

## Explanation

number – The is the original number you want to round up.

num_digits – This signifies the number of digits to which you want to round up the original number.

*Figure 1. Excel ROUNDUP function*

## How to use the ROUNDUP function

The ROUNDUP function is similar to the ROUND function. The only difference is that the ROUNDUP function will always round any numbers between 1 and 9 up.

The ROUNDUP function can round both to the left and right of a decimal point.

When num_digits is greater than 0, the value is rounded up to the right of the decimal point using the given number of decimal places.

When num_digits is less than 0, the original number is rounded up to the left-hand side of the decimal point.

When num_digits = 0, the original number is rounded up to the nearest whole number.

## Leave a Comment