Function Description
| Category | Description |
|---|---|
| Syntax | ROUNDUP(number,num_digits) |
| Function | Returns a number rounded up to the specified number of digits. The first discarded digit causes the result to round up even when it is less than 5. |
| Parameters | number: the number to round num_digits: the number of digits to which the number is rounded |
| Number of Parameters | 2 |
| Parameter Type | Number |
| Return Value Type | Number |
| Notes | If the value of num_digits is greater than 0, the number is rounded to the specified number of decimal places.If the value is equal to 0, the number is rounded to the nearest integer.If the value is less than 0, the number is rounded to the left of the decimal point. For example, -2 rounds number up at the hundreds place. |
Examples
| Formula | Result |
|---|---|
ROUNDUP(2.15,1) | 2.2 |
ROUNDUP(2.149,1) | 2.2 |
ROUNDUP(-1.475,2) | -1.48 |
ROUNDUP(21.5,-1) | 30 |
More Examples
For example, you can use ROUNDUP to remove the decimal part of Cleaned Profit and round the value up to an integer.
