If you have a scenario where you have very clearly defined values e.g. a questionnaire where you have options for a scale. You can download the starting file here.
Scale:
1 = Very dissatisfied
2 = Dissatisfied
3 = Neither satisfied nor dissatisfied
4 = Satisfied
5 = Very satisfied
It can sometimes be easier to use a Switch() function and here I have given you an example using this scale. However you may find that and If() or Xlookup() function or indeed an IFS() function may do the job better
You can download the completed file here.