Formulas and Functions

Chapter 13 Additional Examples and Topics 355
More on Rounding
iWork supports many dierent 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 diers 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.