Combining IF OR and AND functions

Hi There,

Is it possible to combine IF OR AND functions? I can combine IF with AND and IF with OR but not all three.

E.g. Is it possible to put the following into a formula:
'IF A2 AND A3 = A1 OR A4 AND A5 = A1 return yes

Hope you can help.

Many thanks

Try:

=IF(OR(AND(A2=A1,A3=A1),AND(A4=A1,A5=A1)),"Yes","No")

"andyp161" wrote:

>
> Hi There,
>
> Is it possible to combine IF OR AND functions? I can combine IF with
> AND and IF with OR but not all three.
>
> E.g. Is it possible to put the following into a formula:
> 'IF A2 AND A3 = A1 OR A4 AND A5 = A1 return yes
>
> Hope you can help.
>
> Many thanks
>
>
> --
> andyp161
> ------------------------------------------------------------------------
> andyp161's Profile: http://www.excelforum.com/member.php...o&userid=11654
> View this thread: http://www.excelforum.com/showthread...hreadid=534558
>
>

Thank you - this works great.

I am also trying to make the following work, without much success - can you help?

=IF((I5="Executive Consultant"),I5),OR(AND($A7=$A5,$I7="Executive Consultant"),$I7)

e.g. IF I5 = "Executive Consultant" then return I5, OR if A7 = A5 AND I7 = "Executive Consultant" return I7.

Many thanks

Try:

=IF(I5="Executive Consultant",I5,IF(AND($A7=$A5,$I7="Executive
Consultant"),$I7,""))

"andyp161" wrote:

>
> Thank you - this works great.
>
> I am also trying to make the following work, without much success - can
> you help?
>
> =IF((I5="Executive Consultant"),I5),OR(AND($A7=$A5,$I7="Executive
> Consultant"),$I7)
>
> e.g. IF I5 = "Executive Consultant" then return I5, OR if A7 = A5 AND
> I7 = "Executive Consultant" return I7.
>
> Many thanks
>
>
> --
> andyp161
> ------------------------------------------------------------------------
> andyp161's Profile: http://www.excelforum.com/member.php...o&userid=11654
> View this thread: http://www.excelforum.com/showthread...hreadid=534558
>
>