Forum Discussion

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
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.
Steam Leaks Tracker.xlsx21 KB

Serdet

Copper Contributor

May 17, 2021

Hi Sergei,

That works great. Thank you.

Elliot Serdet

SergeiBaklan

Diamond Contributor

May 17, 2021

Serdet , you are welcome