Apple Numbers '08 - Manual (Page 268)

268 Chapter 12 Dictionary of Functions
ROUND
The ROUND function rounds a number to the specified number of places.
ROUND(number, digits)
 number: The number you want to round. It can be a numeric expression in the
function or a reference to a cell containing a numeric expression.
 digits: The number of digits you want to round to, 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, ROUNDUP, ROUNDDOWN,
TRUNC.
ROUNDDOWN
The ROUNDDOWN function rounds a number toward zero to the specified number of
places.
ROUNDDOWN(number, digits)
 number: The number you want to round. It can be a numeric expression in the
function 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.
Examples
ROMAN(12) returns XII.
ROMAN(999) returns CMXCIX.
ROMAN(999,1) returns LMVLIV.
ROMAN(999,2) returns XMIX.
ROMAN(999,3) returns VMIV.
ROMAN(999,4) returns IM.
Examples
ROUND(1.49,0) returns 1.
ROUND(1.50,0) returns 2.
ROUND(1.23456,3) returns 1.235.
ROUND(1111.222,-2) returns 1100.
ROUND(-2.2,0) returns -2.
ROUND(-2.8,0) returns -3.