If Statement

[jimd1768]

I want to use an IF statement that returns 3 values. I can do it to return 2.

Example: I am measuring performance of individuals. If they deliver below 50% I can return the value "Needs Improvement". If they deliver Over 60%, I need to show "Excellent" and finally if they deliver between 50% & 60% I need to return the value "Good".

I am not sure how to show 3 values. Any help would be greatly appreciated.

Thank you in advance

[L-Drr]

Put another IF statement in the first IF statement. For example:

=IF(A1<=50;"Needs improvement";IF(A1>60;"Excellent";"Good"))

My semicolons may have to be commas for you

[jimd1768]

Thank you so much. It worked perfectly.

[L-Drr]

You're welcome!

Thanks for the rep, please mark the thread as solved