Nested If / And / Or ?

[Titian]

Greetings

Is there any way the following can be expressed in single formula?

If A2 = 1 and B2 <= 10 - "Yes"

If A2 = 1 and B2 > 10 - "No"

If A2 = 2 and B2 <= 20 - "Yes"

If A2 = 2 and B2 > 20 - "No"

Thanks in advance.



Dan

[Bryan Hessey]

=IF(OR(AND(A2=1,B2<=10),AND(A2=2,B2<=20)),"Yes",IF(OR(AND(A2=1,B2>10),AND(A2=2,B2>20)),"No",""))

There are options that will leave the cell blank (= "" )

Greetings

Is there any way the following can be expressed in single formula?

If A2 = 1 and B2 <= 10 - "Yes"

If A2 = 1 and B2 > 10 - "No"

If A2 = 2 and B2 <= 20 - "Yes"

If A2 = 2 and B2 > 20 - "No"

Thanks in advance.



Dan

[Titian]

"Bryan Hessey" wrote in message
>
> =IF(OR(AND(A2=1,B2<=10),AND(A2=2,B2<=20)),"Yes",IF(OR(AND(A2=1,B2>10),AND(A2=2,B2>20)),"No",""))
>
> There are options that will leave the cell blank (= "" )
>
>
> Titian Wrote:
>> Greetings
>>
>> Is there any way the following can be expressed in single formula?
>>
>> If A2 = 1 and B2 <= 10 - "Yes"
>>
>> If A2 = 1 and B2 > 10 - "No"
>>
>> If A2 = 2 and B2 <= 20 - "Yes"
>>
>> If A2 = 2 and B2 > 20 - "No"
>>
>> Thanks in advance.
>>
>>
>>
>> Dan
>
>
> --
> Bryan Hessey
> ------------------------------------------------------------------------
> Bryan Hessey's Profile:
> http://www.excelforum.com/member.php...o&userid=21059
> View this thread: http://www.excelforum.com/showthread...hreadid=487142
>

Thanks so much Bryan

it works a treat.

cheers
Dan

[Bryan Hessey]

Good to see, and thanks for the response.

"Bryan Hessey" wrote in message[color=blue]
>
> =IF(OR(AND(A2=1,B2<=10),AND(A2=2,B2<=20)),"Yes",IF(OR(AND(A2=1,B2>10),AND(A2=2,B2>20)),"No",""))
>

it works a treat.

cheers
Dan