Microsoft Office Tutorials and References

In Depth Information

**Rounding Out Your Knowledge**

Figure 7-5:

Using

AutoSum

to work

with other

popular

functions.

Rounding Out Your Knowledge

Excel calculates answers to many decimal places. Unless you’re doing rocket

science, you probably don’t need such precise answers. Excel has a great set

of functions for rounding numbers so they’re usable for the rest of us.

Excel’s rounding functions are really helpful. The other day, my son had a

couple of his friends over. I ordered a large pizza for their lunch. That’s eight

slices for three hungry boys. How many slices does each boy get? Presto

magic, I went over to the computer where Excel was already running (okay, I

am an Excel nut, after all), and I entered this simple formula =8/3.

Of course, Excel gave me the perfect answer. Each boy gets 2.66667 slices.

Have you ever tried to cut 66,667/100,000ths of a slice of pizza? Not easy! This

is the type of answer that rounding is used for. Although, to tell you the truth,

I did solve the pizza problem a different way. I gave them each two slices, and

I ate the last two (pretty good with mushrooms!).

Just plain old rounding

Easy to use, the ROUND function is the old tried-and-true method for

rounding off a number. It takes two arguments — one argument is the number to

round (typically this is a cell reference), and the other argument indicates

how many decimal places to round to.

The ROUND function rounds up or down depending on the number being

rounded. When the value is less than the halfway point of the next significant

digit, then the number is rounded down. When the value is at or greater than

the halfway point, then the number is rounded up: