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
The 2 in this formula represents the number of decimal places you want to round to. You can change this to suit your needs.