The Excel ROUNDUP function is used to round a number up to a specified number of digits.For example, round a number up to one decimal place.
The syntax for the ROUNDUP function is:
=ROUNDUP(number,num_digits)
| Argument | Purpose |
|---|---|
| Number | The number you want to round up |
| num_digits | The number of digits you want to round the number up to. If the num_digits is greater than 0, the number is rounded up to the specified number of decimal points. If the num_digits is 0, the number is rounded up to the nearest integer. If num_digits is less than 0, the number is rounded up to the left of the decimal point. |
Below are examples of the ROUNDUP function being used to round numbers up to a various number of digits.
| Function | Result |
|---|---|
| =ROUNDUP(A1,2) | 5.33 |
| =ROUNDUP(A2,0) | 3 |
| =ROUNDUP(A3,1) | 4.6 |
| =ROUNDUP(A4,-1) | 30 |
