View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default miscalculation in excel

Answer should be 1154.91 using just the figures supplied.

Increase decimal places in the two cells and see what you really have in G23 and
H23

John McGimpsey has some info at this site

http://www.mcgimpsey.com/excel/pennyoff.html


Gord Dibben MS Excel MVP


On 30 Sep 2006 05:26:30 -0700, "GSHEP" wrote:

adding 989.89 to 165.2
cells G23 H23


=G23+H23 in spreadsheet

answer should be 1155.09 calculation given is 1155.04