"tzip123" wrote:
96 €“ 100 value of 1
91 €“ 95 value of 2
86 €“ 90 value of 3
[....]

You could consider VLOOKUP. But since your numbers fit a
pattern, you might consider this (where A1 is the score on
the left):

=1+int((100-A1)/5)