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"...

excel

Formulas and Functions

office 365

m_tarler

Apr 02, 2026

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...

Forum Discussion

Finding return value from multiple columns/cells with specific text