X= a value in a colum

[riley76]

I am creating a spreadsheet to grade a persons performance. There is Unacceptable(.1), unsatisfactory(1.54), below average(.23), average(.31), excellent(.35), and outstanding(.39). I want to be able to put an "X" in the box and have its value sent to the score colum on the end. I listed the value beside the rating above. I have no idea how to accomplish this. As of now I have to type the value in the box and have it autosum to the score colum. any help would be apprciated. I could also email the spreadsheet if someone wants me to.

 

[snoopyhr]

I am creating a spreadsheet to grade a persons performance. There is Unacceptable(.1), unsatisfactory(1.54), below average(.23), average(.31), excellent(.35), and outstanding(.39). I want to be able to put an "X" in the box and have its value sent to the score colum on the end. I listed the value beside the rating above. I have no idea how to accomplish this. As of now I have to type the value in the box and have it autosum to the score colum. any help would be apprciated. I could also email the spreadsheet if someone wants me to.

Just curious, why unsatisfactory has the higher number than Excellent?
Should the ranking be based on the lowest to the highest,?

 

[Scott Huish]

Probably supposed to be .154