View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Toi Toi is offline
external usenet poster
 
Posts: 1
Default Excel 2003 fails to calculate cells correctly

Hi

I have found this disturbing error in excel.

Go to a cell and type in
=1.1-1.2+0.1
and I get
1.38778E-16
instead of zero.

KB78113 does discuss something similar, but I read it as saying that the
close to zero problem was fixed in '97

It is no wonder I am unable to get Oracle to match Excel results. Excel
can't seem to do simple mathematics.