software

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: www.excelforum.com/member.php...oamp;userid=11654
View this thread: www.excelforum.com/showthread...hreadid=534558Try:

=IF(OR(AND(A2=A1,A3=A1),AND(A4=A1,A5=A1)),quot;Yesquot;,quot;N oquot;)

quot;andyp161quot; wrote:

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


Thank you - this works great.

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

=IF((I5=quot;Executive Consultantquot;),I5),OR(AND($A7=$A5,$I7=quot;Executive
Consultantquot;),$I7)

e.g. IF I5 = quot;Executive Consultantquot; then return I5, OR if A7 = A5 AND
I7 = quot;Executive Consultantquot; return I7.

Many thanks--
andyp161
------------------------------------------------------------------------
andyp161's Profile: www.excelforum.com/member.php...oamp;userid=11654
View this thread: www.excelforum.com/showthread...hreadid=534558Try:

=IF(I5=quot;Executive Consultantquot;,I5,IF(AND($A7=$A5,$I7=quot;Executive
Consultantquot;),$I7,quot;quot;))

quot;andyp161quot; wrote:

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