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?