Use of if,or and in formula

[kv.singh]

I want to use if,or and combination for deciding eligible members.

Conditions
1 if number is >= 20 eligible
or
2 if number is >= 15 & amount is >=70000 eligible
or
3 if number is >= 12 & amount is >=100000 eligible

can any one help me

[wk9128]

Try D2 formula

[kv.singh]

If number is >= 20 than member is "eligible' condition not included in above formula.

[AliGW]

I'd use this:

=IF(OR(B2>=20,AND(B2>=15,C2>=70000),AND(B2>=12,C2>=100000)),"ELIGIBLE",""))

[wk9128]

So you want to be like this, then the formula can be like this

D2 formula

[BMV]

Please Login or Register  to view this content.

[kv.singh]

Thanks @AliGW , @w,k9128 , BMV
All formulas are giving expected results.