Forum Discussion

RaveenaAV's avatar
RaveenaAV
Copper Contributor
May 19, 2022
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...
Formulas and Functions
  • Detlef_Lewin's avatar
    Detlef_Lewin
    May 19, 2022

    RaveenaAV 

    =IFS(
  COUNTIFS(C4:F24,"Yes")=COUNTA(C4:F24),"Doing Our Job",
  COUNTIFS(C4:F24,"No"),"Unacceptable",
  TRUE,"Underperforming"
)
RaveenaAV's avatar
RaveenaAV
Copper Contributor
May 19, 2022
Thank you for your reply!
But the above formula seems to return "underperforming" when all the entries are "Yes".
Detlef_Lewin's avatar
Detlef_Lewin
Silver Contributor
May 19, 2022

RaveenaAV 

Not in my world.

 

  • RaveenaAV's avatar
    RaveenaAV
    Copper Contributor
    May 19, 2022
    Thank you very much! I had a text column in between thereby the error.
    • Detlef_Lewin's avatar
      Detlef_Lewin
      Silver Contributor
      May 19, 2022

      RaveenaAV 

      You mean a column with texts that should not be counted?

      Then adjust COUNTA().

       

Resources