Apple iWork '09 - Manual (Page 355)

Chapter 13 Additional Examples and Topics 355
More on Rounding
iWork supports many different functions that round numbers. This section compares
these functions.
To Use this function Comments
Round a number away from
zero to the nearest multiple of a
given number “CEILING” (page 170) Rounding occurs in steps; for
example, the closest multiple of
10. Rounding is away from zero,
so =CEILING(0.4, 1) results in 1
and =CEILING (-0.4, -1) results
in -1.
Round a number away from
zero to the nearest even
number “EVEN” (page 173) Rounding is to the nearest
number evenly divisible by two.
Rounding is away from zero,
so =EVEN(0.4) returns 2 and
=EVEN(-0.4) returns -2.
Round a number toward zero to
the nearest multiple of a given
number “FLOOR” (page 176) Rounding occurs in steps; for
example, the closest multiple of
10. Rounding is toward zero, so
=FLOOR(0.4, 1) results in 0 and
=FLOOR (-0.4, -1) also results
in 0.
Round a number to the nearest
integer that is less than or equal
to a given number “INT” (page 178) Rounding is to the nearest
integer that is less than or
equal to the given number.
Therefore, =INT(0.4) returns 0
and =INT(-0.4) returns -1.
Round a number to the nearest
multiple of a given number “MROUND” (page 183) Rounding is to the nearest
multiple of the given number.
This differs from CEILING,
which rounds up to the
nearest multiple. Therefore,
=MROUND(4, 3) returns 3,
since 4 is closer to 3 than to
the next multiple of 3, which
is 6. =CEILING(4, 3) returns 6,
the nearest multiple of 3 when
rounding up.
Round a number away from
zero to the nearest odd number “ODD” (page 185) Rounding is to the nearest
number not evenly divisible
by two. Rounding is away from
zero, so =ODD(1.4) returns 3 and
=EVEN(-1.4) returns -3.