View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
JE McGimpsey JE McGimpsey is offline
external usenet poster
 
Posts: 4,624
Default excel 2007 850*77.1=100000

This has been posted just about everywhere, and is the subject of
several threads. Please don't add to another one...

You are doing nothing wrong. It's a bug.

In article ,
Kenchr wrote:

I have found a real odd error in excel 2007 if you multiply 850*77.1 the
result is 10000, if you change it to 77.2 or 77.09 it works fine!?!?!?!?!?

Tell me I am doing something wrong in the formula =A1*B1 where cell A1 = 850
and cell B1 = 77.1

thanks

-k