Formula to return multiple answers

[Mccudden]

Hi Everyone,

I am looking for help with a formula to return multiple answers depending a cells input.

For example:

6 = Good performance
5 = Satisfactory performance
4 = Acceptable performance
3 =Requires improvement*

and so.

and so on. I have a basic formula =IF(ISNUMBER(SEARCH("6",B9)),"Good performance","") but I cant seem to adapt it.

Any help will be very much appreciated.

 

[arthurbr]

Perhaps something like = CHOOSE(B9-2,{"requires improvement*","Acceptable performance","Satisfactory performance","Good performance"})

 

[Mccudden]

Thank you! that worked perfectly!

 

[arthurbr]

You're welcome
You can also replace the hard coded array with a range reference, giving more flexibility