values shown do not add up
Posted by Chris Ball on July 27, 2001 11:47 PM
Please can anyone help????
I have a spreadsheet that sometimes needs figures to be shown pro rata. This part I can do but they need to be exact and when I add them together manually they sometimes are 1 out. Is there an easy way to stop this happening. I use Excel 2000 at home and 95 at work
Thanks
Posted by Dax on July 28, 2001 4:05 AM
The reason for this could be that the "numbers" are actually text and therefore won't be included in any calculations. One way to get around this is to use the VALUE function which will turn any text which could be represented as a number into a number.
HTH,
Dax.
Posted by Mark W. on July 28, 2001 5:52 AM
Are you describing rounding error? If so consider
using the Tools | Options... menu command to check
"Precision as displayed" on the dialog's
Calculation tab.
Posted by Chris Ball on July 29, 2001 2:51 PM
The problem is I have a spreadsheet that has to sun columns of figures and then use these figures to calculate pro rata.
When you auto sum the pro rata values they show aas the correct amount but when using the Tools, Options, Precision it is usually 1 out e.g. pro rata values 134.56 162.73 204.42 = 507.71 (which is the figure I require), but if you add them manually it = 507.72.
