Forum Discussion
Excel Formula - formula based on if cell contains
Hi all, Seeing if any of you would be assist, I am slowly learning some advance formulas in Excel and wanted to see if the following was possible. If A1 = Yes and B1 = Yes, then C1 would be “N/A...
Hi Gareth
I'm sure someone will probably have a better way to do this but this should work:
=IFERROR(IFS(AND(A1="Yes",B1="No"), "P3", AND(A1="Yes",B1="Yes"), "N/A", AND(A1="No",B1="No"), "P2"), "Not a valid combo")
I've used IFS for multiple conditions and have also added IFERROR to catch any invalid combos or entries.
Hope that helps. Sample file is attached.
Cheers
Damien