excel not recognising numbers containing 0.1calculated by formulas

[atin]

Problem- Excel not recognising or counting values between '0.01 to 0.99' in
cells containing formula.

My worksheet-

A B C D E
1 Stock Open Sale return Sale Stock should be Calculate if D=0.2
2 0.65 0.45 0.2 0.2
3 5 1 4 0
4 2 2 0 0
5 7 6.8 0.2 0
6 6 5.5 0.5 0
7 9 8.1 0.9 0



Stock should be i.e. D2 to D7 contains formula =A2+B2-C2

I want to calcuate stock which is 'less than 0.2' in 'stock should be' i.e.
D2 to D7.
I used formula =IF(D2=0.2,D2,0)

As you can see it gives right value for D2 but is not giving right value for
D5.

Can anyone help.

In my sheet excel is not recognising values starting from 0.01 to 0.99 in D2
to D7 as it is calculated by formula.

 

[Jacob Skaria]

Atin

I tried with your figures in correct. The formula gives 0.2 In Row 2 and
Row5 . Please try that in a fresh workbook..

If this post helps click Yes

 

[atin]

Please download exact sheet at - http://www.aensia.com/test.zip

In the sheet I want to know stock which is equal to 0.1, 0.2 and so on.
Excel is not giving right value of some (stock equal to 0.1, 0.2 and others).
Though it gives right values for (stock equal to 1.1, 2.1 & so on)

 

[Jacob Skaria]

I have downloaded the file. Sorry I am using 2003 right now...

 

[JoeU2004]

See the discussion under your duplicate thread entitled "0.1 to 0.99 not
recognised or calculated when results from formula" in the same newsgroup.


----- original message -----