View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Chris B Chris B is offline
external usenet poster
 
Posts: 11
Default If function confused with 0.1

Hi,

I have set up the following If function to determine if the answer to a
simple subtraction of two decimal numbers is 0.1.

=IF(C1=0.1,"yes","no")

The calculation is merely C1=A1-B1

However, for some calculations it is giving the answer "no" when the answer
is clearly 0.1!

1.7-1.6 gives a no response as does 1.4-1.3. Interestingly, from 4.1-4 all
answers are no!

Hope someone can help
Cheers