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:
Search JabSto ::




Custom Search