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
Serdet's avatar
Serdet
Copper Contributor
May 07, 2021

SergeiBaklan  

 

Hi Sergei Baklan,

Thanks for your quick reply. I have tried this formula in my spreadsheet and it is not working, when I change cells to blank it does not change the 'Good to Go' column value.

 

I have tried copy & pasting my data over to your spreadsheet and it seems to work perfectly. Columns A - D are all populated by IF formulas, I'm not sure if this has anything to do with it not working.

 

Please see the attached spreadsheet as this may give you an idea as to why it is not working (Data is actually located in columns AF:AI)

 

Kind regards,

 

Elliot 

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

    Serdet 

    To change the check on empty string the formula could be

    =IF(ISNA(XMATCH("",AF3:AI3)), "Yes", "N/A")

    In attached file I changed K3 to test.

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

      SergeiBaklan

       

      That works perfect, thank you very much!

       

      Have a good weekend.

       

      Elliot  

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

        Serdet 

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

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

    Serdet 

    I guess that's since you could have not blank cells, but cells with empty string "" returned by formulas. Empty string doesn't mean the cell is blank, it only looks like like blank.

    I'll modify the formula in short while, have to shift on another task shortly.

Resources