Apple iWork '09 User Manual
Page 356
To
Use this function
Comments
Round a number to the
specified number of places
A positive number indicates
the number of digits (decimal
places) to the right of the
decimal separator to include in
the rounded number. A negative
number indicates the number of
digits to the left of the decimal
separator to replace with zeros
(the number of zeros at the end
of the number). The number
is rounded based on this. So
=ROUND(1125, -2) returns
1,100 and =ROUND(1155, -2)
returns 1,200. Rounding
is away from zero, so
=ROUND(-1125, -2) returns -1,100
and =ROUND(-1155, -2) returns
-1,200.
Round a number down (toward
zero) to the specified number
of places
A positive number indicates
the number of digits (decimal
places) to the right of the
decimal separator to include in
the rounded number. A negative
number indicates the number of
digits to the left of the decimal
separator to replace with zeros
(the number of zeros at the end
of the number). The number
is rounded based on this. So
=ROUND(1125, -2) returns
1,100 and =ROUND(1155, -2)
also returns 1,100, since
rounding is toward zero.
=ROUND(-1125, -2) returns -1,100
and =ROUND(-1155, -2) also
returns -1,100.
356
Chapter 13
Additional Examples and Topics