View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Ron Rosenfeld Ron Rosenfeld is offline
external usenet poster
 
Posts: 5,651
Default miscalculation in excel

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


Then the contents of G23 and H23 is not 989.89 and 165.2

Format the G23 and H23 as General, or Number with a lot of decimal places, and
see what the contents of those cells is really.
--ron