Sliding scale and to return a percent based an a range in reverse order

New Contributor

I want to return a percent based on a scale that is in reverse order.  ie lower number is the better number.



50%   $12.50

75%   $11.00

100%  $9.75


Lookup value  $10.55  is "What Percentage?" based on the chart above?

2 Replies


Do you want linear interpolation? If so:

Let's say the lookup value is in D1.

The percentage is


@Hans Vogelaar 


Thank you,  It worked perfectly!