ROUNDUP(number, num_of_digits)
- Where 'number' is the number to round and
- 'num_of_digits' is the number of digits to which the number is to be rounded.
ROUNDUP() rounds a number to specified number of digits away from 0.
Description
ROUNDUP(number, num_of_digits)
This function is used to round a number up away from zero, to specified number of decimal digits mentioned in the argument.
For Example,
ROUNDUP(67.8,0) returns 68 as a result.
ROUNDUP(6.83112,3) returns 6.832 as a result.
- If 'num_of_digits' is omitted, Calci displays #NaN error message.
- The number is rounded up to the specified number of decimal places, if num_of_digits > 0.
- The number is rounded up to the nearest integer, if num_of_digits = 0.
- The number is rounded up to the left of the decimal point, if num_of_digits < 0.
- If any argument is non-numeric, Calci displays #NaN error message.
ROUNDUP() can also be used for multiple number array as -
ROUNDUP(2.55..7.55,1) that rounds the numbers from 2.5 to 6 in steps of 0.5.
| Number | ROUNDUP |
|---|---|
| 2.5 | 3 |
| 3 | 3 |
| 3.5 | 4 |
| 4 | 4 |
| 4.5 | 5 |
| 5 | 5 |
| 5.5 | 6 |
| 6 | 6 |
- ROUND() can be used to round a number to specified number of digits.
- ROUNDDOWN() can be used to round a number towards zero.
- MROUND() can be used to round a number to desired multiple.