Thread: excel 2007 miscalculation
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Wilson Wilson is offline
external usenet poster
  
Posts: 18
Default excel 2007 miscalculation
try this:
A1 = 154.2
B1 = 1700
C1 = A1*B1 give answer 262140 (correct)
D1 = 4
E1 = C1/D1 give answer 100000 (incorrect, the answer must be 65535)

does anyone know this error?
Reply With QuoteReply With Quote