|
Posted to microsoft.public.excel.worksheet.functions
|
|
|
AutoSum lost a penny
See
http://www.mcgimpsey.com/excel/pennyoff.html
In article ,
PoldenKaz wrote:
Hi I am trying to use autosum to add up a colum of figures but it keeps
loosing a penny. for example
£551.99
£459.99
£402.49
£344.99
£632.44
£114.99
£52.89
when these totals are added together on a calculator the total is 2559.78
but when I use autosum the total appears as 2559.77.
Please can anyone shed any light as to why this may be. I have checked that
there are no other characters in the cells or formula.
|