"How To Excel" Mini-Tutorials
by TheExcelAddict.com
"Helping Average Spreadsheet Users Become Local Spreadsheet Experts"

It Doesn't Add Up Without Rounding !

If you've been using Excel for any length of time, you've undoubtedly come across a situation where you printed off a report for someone and they came back saying that it doesn't add up. That's very common in worksheets where you use division or percentage calculations in your formulas.

You see, Excel stores very exact values in its cells but it displays (and prints) only what you tell it to.

For example if you have a cell formatted to display two decimal places and the formula (=1/3) in that cell returns a result of .333333333, your displayed (and printed) value will be .33. If you have three cells with that same value printed on a report, it would appear to the reader that the total of these should be .99. However, the total of these on your spreadsheet would show 1.00. That's because Excel has added three amounts of .333333333. To avoid this problem, you'll need to adjust your formulas so that they will return a value that is rounded to the number of decimal places you want.

To round a formula to a specific number of decimal places, use

  • =ROUND(originalformula,2)

The 2 in this formula represents the number of decimal places you want to round to. You can change this to suit your needs.

Why not print (CTRL+P) this tip and share it with your friends and associates?

Get more time-saving tips just like this one delivered to you by email every week in my FREE newsletter "Spreadsheet Tips From An Excel Addict". Subscribe at the www.TheExcelAddict.com/Newsletter.htm.
You'll be amazed how much time you'll save just by learning a few of these tips.

Copyright 2003 All Rights Reserved by Francis Hayes (The Excel Addict)

If you came to this page from my Excel Mini-Tutorials page, click here to close this window,
otherwise click here and you'll find lots more time-saving Excel tutorials like this one.