Check a cells value

[hsandeep]

i am trying to solve a scenario....
A1=332.345 B1=331.658 C1=331.229
D1 should give output as 1 provided
Condition1: A1>B1 AND C1<B1
Condition2: Neither of A1, B1 & C1 should be <=0.

If any of abv 2 conditions are not met then D1=0.
What formula needs to be punched in D1?
Thnx in adv.

 

[wigi]

Perhaps:

=IF(AND(A1>B1,A1>C1,MIN(A1:C1)>0),1,0)

 

[Snakehips]

hsandeep,

Try....
=IF(AND(A1>B1,B1>0,C1>0),1,0)

Hope that helps.

 

[wigi]

True, the MIN( ) function could be simplified given the other conditions in the AND function.

 

[hsandeep]

I missed out 2 words. They are Condition1: A1>B1 AND
Condition2: C1<B1<b1
<b1<b1<b1< font=""><b1

</b1
<b1
Condition3: Neither of A1, B1 & C1 should be <=0</b1
<b1
</b1
</b1<b1<b1<></b1

 

[hsandeep]

Condition2:C1 less than B1<b1< html=""></b1<>

 

[Snakehips]

If I understand correctly then try....

=IF(AND(A1>B1,B1>C1,C1>0),1,0)

 

[hsandeep]

Thnks it WORKS.

 

[hsandeep]

=IF(AND(A1>B1,B1>C1,C1>0),1,0)[/QUOTE]
Further Condition4: C1 is greater than B1 the D1=2. Pls answer?

 

[wigi]

If you have over 400 posts at MrExcel and you're here for more than 5 years, this kind of formula should be super easy.
Please make it yourself and if problems arise please let us know. Post your own formula in that case and explain what is going wrong.