Forum Discussion

riana625's avatar
riana625
Copper Contributor
Nov 17, 2022

IF function: using a true or false condition value but over multiple columns

Need help please.

 

Easy to do the IF function for a Yes and No column but how do i do a scorecard with three columns making use of the working Like "need attention" - Good - Excellent where by Needs attention scores 0 and Good scores ,5 and Excellent 1,0?

 

Please assist.

 

 

Formulas and Functions

1 Reply

Sort By
  • dscheikey's avatar
    dscheikey
    Bronze Contributor
    Nov 19, 2022

    riana625 

    I hope I understand your question correctly. If you want to evaluate a cell according to several specific expressions, this can be done with very different functions. All formulas assume that your value is in A1.

    =IFS(A1="Needs attention",0,A1="Good scores",5,A1="Excellent",1)

=SWITCH(A1,"Needs attention",0,"Good scores",5,"Excellent",1,"")

=XLOOKUP(A1,{"Needs attention";"Good scores";"Excellent"},{0;5;1},"")

     

Resources