# If more than condition forumula

1. ## 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....  Register To Reply

2. ## Re: 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" <coreymcconnell@splicetech.com.au> wrote in message
news:eciwHEBlGHA.3720@TK2MSFTNGP03.phx.gbl...
>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....
>  Register To Reply

3. ## Re: If more than condition forumula

You are a champ.
Perfect.

Thnx
Corey....

"Biff" <biffinpitt@comcast.net> wrote in message
news:urw5PXBlGHA.4444@TK2MSFTNGP02.phx.gbl...
> 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" <coreymcconnell@splicetech.com.au> wrote in message
> news:eciwHEBlGHA.3720@TK2MSFTNGP03.phx.gbl...
>>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....
>>

>
>  Register To Reply

4. ## Re: If more than condition forumula

You're welcome!

Biff

"Corey" <coreymcconnell@splicetech.com.au> wrote in message
news:uMct4vBlGHA.408@TK2MSFTNGP03.phx.gbl...
> You are a champ.
> Perfect.
>
> Thnx
> Corey....
>
> "Biff" <biffinpitt@comcast.net> wrote in message
> news:urw5PXBlGHA.4444@TK2MSFTNGP02.phx.gbl...
>> 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" <coreymcconnell@splicetech.com.au> wrote in message
>> news:eciwHEBlGHA.3720@TK2MSFTNGP03.phx.gbl...
>>>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....
>>>

>>
>>

>
>  Register To Reply