| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
If more than condition forumula
I am trying to set up an IF calculation as below:
=IF(L6="ABC",100,IF(L6="DEF",200,IF(L6="GHI",50))) The baove is fine but i now need a 2nd condition as below. I want to add a second condition to it say like: =IF(P6="" and L6="ABC",100,IF(P6="" and L6="DEF",200,IF(P6="" and L6="GHI",50, IF(P6="Yes" and L6="ABC",150, IF(P6="Yes" and L6=DEF",250, IF(P6="Yes" and L6="GHI",75)))))) I try this but get an error. What syntax do i use other than (and) to include a 2nd condition ?? Corey.... |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
If more than condition forumula
Hi!
Here's one way: =IF(AND(P6="",L6<""),VLOOKUP(L6,{"ABC",100;"DEF", 200;"GHI",50},2,0),IF(AND(P6="Yes",L6<""),VLOOKUP (L6,{"ABC",150;"DEF",250;"GHI",75},2,0),"")) Biff "Corey" wrote in message ... I am trying to set up an IF calculation as below: =IF(L6="ABC",100,IF(L6="DEF",200,IF(L6="GHI",50))) The baove is fine but i now need a 2nd condition as below. I want to add a second condition to it say like: =IF(P6="" and L6="ABC",100,IF(P6="" and L6="DEF",200,IF(P6="" and L6="GHI",50, IF(P6="Yes" and L6="ABC",150, IF(P6="Yes" and L6=DEF",250, IF(P6="Yes" and L6="GHI",75)))))) I try this but get an error. What syntax do i use other than (and) to include a 2nd condition ?? Corey.... |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
If more than condition forumula
You are a champ.
Perfect. Thnx Corey.... "Biff" wrote in message ... Hi! Here's one way: =IF(AND(P6="",L6<""),VLOOKUP(L6,{"ABC",100;"DEF", 200;"GHI",50},2,0),IF(AND(P6="Yes",L6<""),VLOOKUP (L6,{"ABC",150;"DEF",250;"GHI",75},2,0),"")) Biff "Corey" wrote in message ... I am trying to set up an IF calculation as below: =IF(L6="ABC",100,IF(L6="DEF",200,IF(L6="GHI",50))) The baove is fine but i now need a 2nd condition as below. I want to add a second condition to it say like: =IF(P6="" and L6="ABC",100,IF(P6="" and L6="DEF",200,IF(P6="" and L6="GHI",50, IF(P6="Yes" and L6="ABC",150, IF(P6="Yes" and L6=DEF",250, IF(P6="Yes" and L6="GHI",75)))))) I try this but get an error. What syntax do i use other than (and) to include a 2nd condition ?? Corey.... |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
If more than condition forumula
You're welcome!
Biff "Corey" wrote in message ... You are a champ. Perfect. Thnx Corey.... "Biff" wrote in message ... Hi! Here's one way: =IF(AND(P6="",L6<""),VLOOKUP(L6,{"ABC",100;"DEF", 200;"GHI",50},2,0),IF(AND(P6="Yes",L6<""),VLOOKUP (L6,{"ABC",150;"DEF",250;"GHI",75},2,0),"")) Biff "Corey" wrote in message ... I am trying to set up an IF calculation as below: =IF(L6="ABC",100,IF(L6="DEF",200,IF(L6="GHI",50))) The baove is fine but i now need a 2nd condition as below. I want to add a second condition to it say like: =IF(P6="" and L6="ABC",100,IF(P6="" and L6="DEF",200,IF(P6="" and L6="GHI",50, IF(P6="Yes" and L6="ABC",150, IF(P6="Yes" and L6=DEF",250, IF(P6="Yes" and L6="GHI",75)))))) I try this but get an error. What syntax do i use other than (and) to include a 2nd condition ?? Corey.... |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| complicated If condition? | Excel Worksheet Functions | |||
| conditional formatting - multiple condition | Excel Discussion (Misc queries) | |||
| count duplicate (or, inversely, unique) entries, but based on a condition | Excel Worksheet Functions | |||
| Condition IF | Excel Discussion (Misc queries) | |||
| Add condition to formula | Excel Worksheet Functions | |||
Linear Mode
