Microsoft Office Tutorials and References

In Depth Information

**Rounding Out Your Knowledge**

CEILING does the opposite. It increases a positive number away from 0 and

also increases a negative number away from 0, which in absolute terms

means the number is getting smaller.

For both the FLOOR and CEILING functions, the first and second arguments

must match signs. Trying to apply a positive number with a negative multiple,

or vice versa, results in an error.

Here’s how to use either the FLOOR or CEILING function:

1. Enter a number in any cell.

2. Position the cursor in the cell where you want the results to appear.

3. Enter either
=FLOOR(
or
=CEILING(
to begin the function entry.

4. Click the cell where you entered the number.

5. Enter a comma (
,).

6.Enteranumberthatisthenextmultipleyouwanttoroundthe

number to.

For example, to get the floor value, at the ones place, make sure 1 is the

second argument. The first argument should, of course, be a number

larger than 1, and should be a decimal value, like this: =Floor(19.77, 1).

This returns 19 as the floor, but hey — don’t hit the ceiling about it!

7. Type a
), and press the Enter key.

Rounding to the next even or odd number

The EVEN and ODD functions round numbers away from 0. The EVEN

function will round a number to the next highest even integer. ODD rounds a

number to the next highest odd integer. Table 7-4 has examples of how these

functions work.

Table 7-4

Rounding to Even or Odd Integers

Example of

Function

Result

Comment

4

Rounds to the next even integer, moving away

from 0.

=EVEN(3)

=EVEN(4)

4

Because 4 is an even number, no rounding takes

place. The number 4 itself is returned.

=EVEN(4.01)

6

Rounds to the next even integer, moving away

from 0.