About Us

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

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How to SUM on a condition?	trant	Excel Worksheet Functions	2	April 2nd 09 12:32 AM
if condition	Malik Nadeem	Excel Discussion (Misc queries)	5	January 13th 09 08:55 AM
lookup with multiple condition, but one condition to satisfy is en	Eddy Stan	Excel Worksheet Functions	2	October 27th 07 02:06 PM
Combine an OR condition with an AND condition	Will	Excel Discussion (Misc queries)	1	April 6th 07 03:52 PM
Condition 1 overules condition 2?	Bultgren	Excel Worksheet Functions	2	January 20th 06 12:29 PM

Menu

About Us