Forum Discussion

Serdet's avatar
Serdet
Copper Contributor
May 07, 2021
Solved

Multiple Condition IF Statement

Hi All,   I have a dataset similar to the below;   Mech Complete? Scaffold Erected Insulation Removed WOL Raised Good to Go? Yes N/A Yes     N/A Yes Yes N/A   N/A N/A Ye...
excel
Formulas and Functions
SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
May 07, 2021

Serdet 

Elliot, glad to help. Have a nice weekend too.

Serdet's avatar
Serdet
Copper Contributor
May 14, 2021

SergeiBaklan 

 

Hi Sergei,

 

I have now added a new column which has to come into the equation and was wondering if you could give me a helping hand.

 

A new column called 'On Hold' has been added to the end of the table (let's say column Z).

 

If fields within this column state 'On Hold' I need the previous 'Good to Go' column to state "N/A".

 

I hope this is all clear.

 

Cheers

 

Elliot 

  • SergeiBaklan's avatar
    SergeiBaklan
    Diamond Contributor
    May 15, 2021

    Serdet 

    You may wrap the formula with one more condition

    =IF(Z3="On Hold", "N/A",  IF(ISNA(XMATCH("",AF3:AI3)), "Yes", "N/A"))
    • Serdet's avatar
      Serdet
      Copper Contributor
      May 17, 2021
      Hi Sergei,

      That works great. Thank you.

      Elliot Serdet