Roundup – Apple Numbers '08 User Manual
Page 269
Chapter 12
Dictionary of Functions
269
Notes
Other functions related to rounding numbers: CEILING, INT, ROUND, ROUNDUP, TRUNC.
ROUNDUP
The ROUNDUP function rounds a number away from zero to the specified number of
places.
ROUNDUP(number, digits)
 number: The number you want to round. It can be a number, numeric expression, or
a reference to a cell containing a numeric expression.
 digits: The number of digits of the result relative to the decimal point. A positive
number represents digits (decimal places) to the right of the decimal point. A
negative number specifies digits to the left of the decimal point.
Notes
Other functions related to rounding numbers: CEILING, INT, ROUND, ROUNDDOWN,
TRUNC.
Examples
ROUNDDOWN(1.49,0) returns 1.
ROUNDDOWN(1.50,0) returns 1.
ROUNDDOWN(1.23456,3) returns 1.234.
ROUNDDOWN(1111.222,-2) returns 1100.
ROUNDDOWN(-2.2,0) returns -2.
ROUNDDOWN(-2.8,0) returns -2.
Examples
ROUNDUP(1.49,0) returns 2.
ROUNDUP(1.50,0) returns 2.
ROUNDUP(1.23456,3) returns 1.235.
ROUNDUP(1111.222,-2) returns 1200.
ROUNDUP(-2.2,0) returns -3.
ROUNDUP(-2.8,0) returns -3.