if & And condition
 

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

if & And condition
 

On Sun, 24 Jan 2010 03:44:06 -0500, shajizz
wrote:


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


Try this formula:

=IF(A20<=B20,C20<=D20,D20<=E20)

Hope this helps / Lars-Åke

if & And condition
 

"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

if & And condition
 

Thanks a lot

'Joe User[_2_ Wrote:
;3622185']"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 -




--
shajizz