|
ROUNDUP |
  
|
|
ROUNDUP |
|
This function rounds the specified number up to the nearest number, using the specified number of decimal places.
Syntax
ROUNDUP(value,places)
Arguments
Use the value argument to specify the number to round. Use the places argument to specify the number of decimal places. The places argument has these rules:
| • | Set places to a value greater than zero to round to the specified number of decimal places. |
| • | Set places to zero to round to the nearest whole number. |
| • | Set places to a value less than zero to round the value left of the decimal to the nearest ten, hundred, etc. |
Remarks
Regardless of the sign of the number specified by the value argument, the number is rounded away from zero.
Data Types
Accepts numeric data for both arguments. Returns numeric data.
Examples
ROUNDUP(A3,–2)
ROUNDUP(C4,B2)
ROUNDUP(R1C2, 2)
ROUNDUP(PI(),5) gives the result 3.14160
ROUNDUP(29.2,-2) gives the result 100
ROUNDUP(-1.963,0) gives the result -2
See Also