"shajizz" :
If A20=<B20, only I want to check C20=<D20,
if A20=<B20 is not true iwant to check D20=<E20

Perhaps:

=if(A20<=B20, if(C20<=D20, 1, 2), if(D20<=E20, 3, 4))

Or do you mean that you wish to optimize the following:

=if(A20<=B20, if(C20<=D20, 1, 2), if(D20<=E20, 1, 2))

which might make sense to optimize if 1 and 2 are really complex
expressions.

Perhaps:

=if(or(and(A20<=B20,C20<=D20),and(A20B20,D20<=E20 )), 1, 2)

If you are concerned about nesting levels, the above logic is equivalent to
either of the following:

=if(or((A20<=B20)*(C20<=D20),(A20B20)*(D20<=E20)) , 1, 2)

=if((A20<=B20)*(C20<=D20)+(A20B20)*(D20<=E20), 1, 2)


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

"shajizz" wrote in message
...

Dear friends..

I want to use fromula that if one logical condition is correct want to
go another logical condition eg:- If A20=<B20, only I want to check
C20=<D20, if A20=<B20 is not true iwant to check D20=<E20, anybody can
help me please..




--
shajizz