Nesting AND/OR into IF Funtion

[stan]

Hi Gurus.

I have 3 columns tracking status - A,B,C. The value in
each column can be 'x' or blank. I am trying to create an
IF Statement that will return True if column A equals x
and if either column B or C equals x.

Thank you for your guidance.

 

[Paul]

Hi Gurus.

I have 3 columns tracking status - A,B,C. The value in
each column can be 'x' or blank. I am trying to create an
IF Statement that will return True if column A equals x
and if either column B or C equals x.

Thank you for your guidance.

=IF(AND(A1="x",OR(B1="x",C1="x")),ValueIfTrue,ValueIfFalse)

 

[Guest]

I cannot get this statement to work.

-----Original Message-----

(B1="x",C1="x")),ValueIfTrue,ValueIfFalse)


.

 

[Manuela]

Hi Stan,

Try this. Let x=4, then write the following formula:

=IF(A2=4,IF(B2=4,"True",IF(C2=4,"True","0")),"0")

This should return a "True" for your condition (A=4 and
either B=4 or C=4) and a "0" if the condition is not
met. Hope this helps.

Good luck!

Best,
Manuela