Thanks for formula, it works. But can you explain the logic of formula. I am
not able to understand it exactly.

"Teethless mama" wrote:

=IF(ROUND(L7,2)=0.1,L7,"")


"atin" wrote:

Problem- Problem- Excel not recognising or counting values between '0.01 to
0.99' in
cells containing formula. Exact sheet can be downloaded at-
http://www.aensia.com/test.zip

In the sheet you download - I want to know which stock is equal to 0.1, 0.2,
0.3 and so on.

Excel is not giving right values in (stock equal to 0.1, 0.2 and others).

Is there any solution to this.