we have changed the score from 1 to 5 by words: Excellent, very good, good, sufficient and not sufficient.
I have defined data area with that values and the user can now choose only from a list with this values. In A1, A2, A3 etc.
In B1, B2, B3 etc. I have a simple formula which used so far the figure 1 to 5. Now I have words...
My first thought is to work with a IF formula with 5 cases but I'm sure there is a much simpler way.
Formula was A1/5 =