"atin" wrote:
You first download sheet at- http://www.aensia.com/test.zip

I am unable to look at the xlsx file in that zip file. Without it, I am
unable to understand what you are asking for.


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

"atin" wrote in message
...
I am trying to show stock which is equal to 0.1, 0.2, 0.3 and others. It is
important for knowing me which stock is equal to above values.

Excel is not giving right values in (stock equal to 0.1, 0.2 & others).
Stock less than 1 donot solve my purpose.

You first download sheet at- http://www.aensia.com/test.zip


"JoeU2004" wrote:

There are so many inconsistencies in your posting, it is difficult to
know
what question(s) you are really asking.

I suspect the root cause of whatever problem you are having is the fact
that
most decimal fractions are not represented exactly in Excel (and most
applications). So results of even simple arithmetic does not always
exactly
match the displayed number. For example, what appears to be 0.2,
resulting
from a formula, might not exactly match the constant 0.2 that you might
enter.

Generally, the solution is to use ROUND one way or another.

For example, where you have =formula in a cell formatted as General or
even
as Number with 2 decimal places, you might change that to
=ROUND(formula,2)
if your intention is for the result to match a constant or other formula
results to within 2 decimal places. Do not rely on formatting to
accomplish
that. That only affects the appearance of the value; it does not affect
the
exact underlying value.

Alternatively, for example, where you have IF(D2=0.2,...), you could
write
IF(ROUND(D2,1)=0.2,...).

I hope that addresses some, if not all, of your problem somehow.


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

"atin" wrote in message
...
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

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.

You can download the original sheet giving problem at-
http://www.aensia.com/test.zip