ROUNDUP
Description
Rounds number to the nearest number away from zero (up if positive; down if
negative), to the number of decimal places that you specify.
Syntax
ROUNDUP(
number
,
num_digits
)
- number: The number to round.
- num_digits: The number of decimal places to round to. Specify 0 to round up to the closest integer. A positive num_digits specifies the number of digits to the right of the decimal point. A negative num_digits specifies the number of digits to the left of the decimal point.
Example
Formula | Result |
|---|---|
=ROUNDUP(12.34,0) | 13 |
=ROUNDUP(-12.34,0) | -13 |
=ROUNDUP(12.34,-1) | 20 |
=ROUNDUP(-12.34,-1) | -20 |