Forum Discussion
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...
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.
You may wrap the formula with one more condition
=IF(Z3="On Hold", "N/A", IF(ISNA(XMATCH("",AF3:AI3)), "Yes", "N/A"))
Hi Sergei,
That works great. Thank you.
Elliot Serdet
That works great. Thank you.
Elliot Serdet
Serdet , you are welcome