Forum Discussion
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 | Yes | N/A | |
| N/A | Yes |
I need a formula column E ('Good to Go') to perform the following logic;
If cells in columns A - D contain "Yes" or "N/A" formulate to "Yes"
If cells in columns A - D contain a single 'Blank Cell' formulate to 'Blank'
Any help will be much appreciated!
Elliot
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.
10 Replies
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
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.
