Microsoft Office Tutorials and References

In Depth Information

**Rounding Out Your Knowledge**

Here’s how to use either the ROUNDUP or ROUNDDOWN function:

1. In a cell of your choice, enter a number with a decimal portion.

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

3. Enter either
=ROUNDUP(
or
=ROUNDDOWN(
to begin the function

entry.

4. Click the cell where you entered the number.

5. Enter a comma (
,).

6. Enter a number to indicate how many decimal places to round to.

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

Rounding to the multiple of choice

The FLOOR and CEILING functions take directional rounding to a new level.

With these functions, the second argument is a multiple to which to round to.

What does that mean?

Well, imagine this: You’re a human resources manager and you need to

prepare a summary report of employee salaries. You don’t need the figures to be

reported down to the last penny, just rounded to the closest $250 multiple.

Either FLOOR or CEILING can be used to do this. For this example, FLOOR

can be used to round down to the closest multiple of $250 that is less than

the salary, or CEILING can be used to round up to the next $250 multiple

greater than the salary. Figure 7-6 shows how both FLOOR and CEILING

return rounded values.

Figure 7-6:

Using

FLOOR or

CEILING to

round to a

desired

multiple.

FLOOR and CEILING exceed the rounding ability of ROUND, ROUNDUP,

and ROUNDDOWN. These three functions can use the positioning of digit