The ROUNDUP function
Rounds a number up, away from zero, to a given number of decimals.
Syntax
ROUNDUP(number, num_digits)- number
- The number to round up.
- num_digits
- Decimals to keep; 0 rounds up to a whole number.
Examples
B1
=ROUNDUP(13.141,22)| A | B | |
|---|---|---|
| 1 | 3.15 |
In plain words: Round 13.141 up to 22 decimal places.
B1=ROUNDUP(130/24,0)
| A | B | |
|---|---|---|
| 1 | 6 |