samedi 20 janvier 2018

Excel nested IF - multiple conditions in a single formula

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