ROUNDUP
Name
Round up
Description
Rounds the specified number up to the nearest number, using the specified number of decimal places.
Syntax
ROUNDUP(value1, value2)
Remarks
Use the value1 argument to specify the number to round. Use the value2 argument to specify the number of decimal places.
Note the following about the value2 argument:
- Set value2 to a value greater than zero to round to the specified number of decimal places.
- Set value2 to zero to round to the nearest whole number.
- Set value2 to a value less than zero to round the value left of the decimal to the nearest ten, hundred, etc.
Regardless of the sign of the number specified by the value1 argument, the number is rounded away from zero.
See also CEILING, EVEN, FLOOR, INT, ODD, ROUND, ROUNDDOWN, TRUNC.
Data Type
Accepts numeric data for both arguments. Returns numeric data. For more information, see Data Type for Each Cell Type.
Example
ROUNDUP(R1C2, 2)
ROUNDUP(A3, –2)
ROUNDUP(C4,B2)
ROUNDUP(PI(),5)=3.14160
ROUNDUP(29.2,-2)=100
ROUNDUP(-1.963,0)=-2