#1
|
|||
|
|||
Rounding values inconsistent
Hope this is easy.
I have a series of calculations and appear to be having trouble with rounding. I'll do my best to explain. Cells C2 through C7 are multiplied by a different 'static' number and rounded to 2 decimal places. I then add C2 through C7 and put the sum in C9. With frequency, the total showing in C9 is NOT equal to the values shown in C2 >C7. If the numbers don't match, the difference is always 0.01. I suspect this is due to the rounding. How do I get the value in C9 to give an accurate value? Or, is the C9 value correct but one of the values in C2>C7 wrong? |
|
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 |