"George" wrote:

A simple VLOOKUP should do the trick

Col A Col B
0 1
5 2
10 3
etc.
85 10
100 -1 (-1 to signify error)

=VLOOKUP(A1,$B$1:$B$B11,2)

George

Thanks for the reply, but that would be a little cumbersome, as for every
number from 0 to 100 I would have to place in a table with its corrosponding
result. I will use this, unless someone else has a better option.