ROUNDUP
Rounds a number up (to a greater value) to the specified number of digits.
Syntax
=ROUNDUP(value, digits)
Arguments
| Argument | Type | Description |
|---|---|---|
| value | Number | The value to round |
| digits | Number | (Optional) The number of digits to round the value, defaults to 0 |
Examples
=ROUNDUP(2.5)→3
Rounds the value 2.5 to 1 digit
=ROUNDUP(3.14159, 2)→3.15
Rounds the value 3.14159 to 2 digits
=ROUNDUP(-8192, -2)→-8100
Rounds the value -8192 to 2 digits
Updated over 1 year ago