ExcelBanter - View Single Post

shajizz[_4_]

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