Nesting AND/OR into IF Funtion

  • Thread starter Thread starter stan
  • Start date Start date
S

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.
 
stan said:
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.
Click to expand...

=IF(AND(A1="x",OR(B1="x",C1="x")),ValueIfTrue,ValueIfFalse)
 
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
 
Back
Top