Apple numbers User Manual

Page of 295
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(numberdigits)
 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.