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.

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
---------------
Jacob Skaria


"atin" wrote:

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.

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" wrote:

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
---------------
Jacob Skaria


"atin" wrote:

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.

I have downloaded the file. Sorry I am using 2003 right now...
--
If this post helps click Yes
---------------
Jacob Skaria


"atin" wrote:

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" wrote:

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
---------------
Jacob Skaria


"atin" wrote:

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.

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 -----

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

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
---------------
Jacob Skaria


"atin" wrote:

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.