I am trying to assign levels of recommendation based on certain values in cell C.
However, I am not sure why this IFS statement is returning with errors.
=IFS(C2< =2.00, “Do Not Recommend”, C2 <=3.33, “Do Not Recommend/Borderline”, C2 <=3.34, “Recommend”, C2=>3.78, “Strongly Recommend”)
Lastly: If I wanted to assign the cell above TWO possible final recommendations, would it be an IF OR statement. For example... IF a candidate is "Do not Recommend" (Cell C3), they can be rejected or placed on hold. How would I reflect that in the code.
Aucun commentaire:
Enregistrer un commentaire