Forum Discussion
Solved
Excel Formula for multiple conditions
Hi I'm trying to work out a formula for the following conditions in a range of cells, between the options of "Yes", "No" and "Mostly" 1.If all answers "Yes" then "Doing Our Job" 2.If a mixture...
=IFS( COUNTIFS(C4:F24,"Yes")=COUNTA(C4:F24),"Doing Our Job", COUNTIFS(C4:F24,"No"),"Unacceptable", TRUE,"Underperforming" )
=IFS(
COUNTIFS(C4:F24,"Yes")=COUNTA(C4:F24),"Doing Our Job",
COUNTIFS(C4:F24,"No"),"Unacceptable",
TRUE,"Underperforming"
)- Thank you for your reply!
But the above formula seems to return "underperforming" when all the entries are "Yes".- Thank you very much! I had a text column in between thereby the error.
