Apple iWork '09 User Manual
Page 357
Chapter 13
Additional Examples and Topics
357
To
Use this function
Comments
Round a number up (away from
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,200 and =ROUND(1155, -2)
also returns 1,200, since
rounding is away from zero.
=ROUND(-1125, -2) returns -1,200
and =ROUND(-1155, -2) also
returns -1,200.
Truncate a number at 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 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). Extra digits
are stripped from the number.
So =TRUNC(1125, -2) returns
1,100 and =TRUNC(1155, -2) also
returns 1,100.