View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
VivienW VivienW is offline
external usenet poster
 
Posts: 11
Default Incorrect result for simple SUM formula

Hello,

Does anyone know why Excel sometimes give an incorrect result when adding
the contents of cells? It may only be 1p out but even if I increase the
decimal places it doesn't seem to make sense as the decimal places are
showing a lesser number than the +1p error.

e.g. =SUM(D12:D22) result 13.75 (should be 13.76) increase decimal places
result becomes 13.74643
--
Cheers, V