Thread: Excel 2007- formula =SUM(850*77.1) returns incorrect answer = 1000
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Diane Diane is offline
external usenet poster
  
Posts: 96
Default Excel 2007- formula =SUM(850*77.1) returns incorrect answer = 1000
Enter the formula: =SUM(850*77.1) and you get 100000. In 2003, you get the
correct answer of 65535. Any idea why?
Reply With QuoteReply With Quote