Forum Discussion
Solved
Finding return value from multiple columns/cells with specific text
Hello, I have to verify multiple cells (C2 to F2) with two possible statuses: "Eligible" and "Not Eligible". In Excel, would it be possible to: If all cells "Eligible", then the result is "Passed"...
yes, try this:
=IFS(AND(D3:G3="Eligible"),"Passed",OR(D3:G3="Consult"),"No Result",OR(D3:G3="Not Eligible"),"Failed",1,"Error")here is the result:
I will try to attach the file...
