Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to SUM on a condition? | Excel Worksheet Functions | |||
if condition | Excel Discussion (Misc queries) | |||
lookup with multiple condition, but one condition to satisfy is en | Excel Worksheet Functions | |||
Combine an OR condition with an AND condition | Excel Discussion (Misc queries) | |||
Condition 1 overules condition 2? | Excel Worksheet Functions |