Microsoft Office Tutorials and References

In Depth Information

**Rounding Out Your Knowledge**

3. Enter
=ROUND(
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 functions make the most sense when the first argument is a cell

reference, not an actual number. Think about it: If you know what a number

should appear as, you would just enter the number — you would not need a

function to round it.

Rounding in one direction

Excel has a handful of functions that round numbers either always up or

always down. That is, when rounding a number, the functions that round

down will always give a result that is lower than the number itself. Functions

that round up, of course, always give a higher number. These functions are

useful when letting the good ol’ ROUND function determine which way to

round just isn’t going to do.

A few of these rounding functions not only round in the desired direction

but even allow you to specify some additional ways of rounding. The EVEN

and ODD functions, for example, round respectively to the closest even or

odd number. The CEILING and FLOOR functions let you round to a multiple.

EVEN, ODD, CEILING, and FLOOR are discussed later in this section.

Directional rounding, pure and simple

ROUNDUP and ROUNDDOWN are similar to the ROUND function. The first

argument to the function is the cell reference of the number to be rounded.

The second argument indicates the number of decimal places to round to.

But unlike the plain old ROUND, the rounding direction is not based on the

halfway point of the next significant digit but rather on which function

you use.

For example, =ROUND(4.22,1) returns 4.2, but =ROUNDUP(4.22,1) returns

4.3. ROUNDDOWN, however, returns 4.2 because 4.2 is less than 4.22. Table

7-2 shows some examples of ROUNDUP and ROUNDDOWN.