View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
JLatham JLatham is offline
external usenet poster
 
Posts: 3,365
Default miscalculation in excel

Excel 2003 says 989.89+165.2 is 1155.09
G23 contains 989.89
H23 contains 165.2
I23 set as =G23+H23
shows 1155.09
Something else in the formula you're using?

"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