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
Here you go: I had the Pass/Fail/Missing data in cell A1 and the Yes/No/NA data in cell B1
=IF(AND(A1="Passed",B1="Yes"),"Match",IF(AND(A1="Failed",B1="No"),"Match",IF(AND(A1="Missing",B1="N/A"),"Match","No")))
