Forum Discussion
Solved
Using IF Function with three scenarios
I am having trouble writing a formula to get the outcome I want. I want column J to look at two data sources (column F and column H) and determine if they agree. If they do I want it to say "Matc...
In general formula works, couple of points
- to check if the cell returns #N/A error you shall by ISNA() function, not by comparing with error text;
- IFS checks conditions one by one and stops working after the first TRUE, thus better error checking move on the first place
=IFERROR(IFS(AND(J2="Missing",ISNA(L2)), "Match", AND(J2="Passed",L2="Yes"),"Match", AND(J2="Failed",L2="No"),"Match",TRUE,"No"),"No")
Result is like here
and attached
In general formula works, couple of points
- to check if the cell returns #N/A error you shall by ISNA() function, not by comparing with error text;
- IFS checks conditions one by one and stops working after the first TRUE, thus better error checking move on the first place
=IFERROR(IFS(AND(J2="Missing",ISNA(L2)), "Match", AND(J2="Passed",L2="Yes"),"Match", AND(J2="Failed",L2="No"),"Match",TRUE,"No"),"No")
Result is like here
and attached