![]() |
|
#5
|
||||
|
||||
|
I agree with your diagnosis, required—it has to be a rounding issue—and with gebobs' suggestion. But I'll expand on it a bit in case there's still confusion: As a matter of picky terminology, I would say that the value in C9 is accurate, just not precise.
Take an example: Code:
3.14159265359 2.71828182846 2.99792458000 1.41421356237 Now tell Excel to display them to just one decimal point, like this: Code:
3.1 2.7 3.0 1.4 What do you do about it? Well, it depends on your needs. It would probably be more accurate for many purposes to leave it as it is, giving 10.3 as the sum rather than 10.2. But if you need to for some reason, you can round the individual numbers to their truncated form, and the sum of those values (rather than the real ones) will come out to 10.2 as you expected. Extra credit for identifying the sample numbers above.
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
Inconsistent Formatting
|
YEG_V | Word Tables | 3 | 05-08-2013 03:06 PM |
| Custom formatting code - rounding problem | venkys4u | Excel | 1 | 08-14-2012 07:45 PM |
Standard Dev. Rounding - Excel
|
judicial85 | Excel | 1 | 08-28-2011 05:41 PM |
| Inconsistent Margins | judyfogarty | Word | 0 | 08-01-2010 02:54 AM |
Federal financial rounding?
|
markg2 | Excel | 6 | 05-26-2010 09:54 AM |