View Single Post
 
Old 06-04-2014, 08:42 AM
required_username required_username is offline Windows 8 Office 2010 32bit
Novice
 
Join Date: May 2013
Posts: 28
required_username is on a distinguished road
Default 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?
Reply With Quote