Calculate percentage in range of a value given a high point and a low point

[GuyGadois]

I am looking for a formula that will calculate the Percentage in range a value is compared to two other values (as it pertains to stock values). I am looking for values in the last column that will tell where in the range value in last category is compared to the high and low. A 100% would represent the last equaling the High while a 0% will equal an Annual Low.

Cheers!

Annual High	Annual Low	Last	% in Range
186.3	113.43	113.06
258.45	198.64	227.03
64.285	40.82	40.68
57.9599	32.3	31.85
116.33	95.48	103.755
172.96	106.06	109.14
111.28	66.88	75.95

 

[Peter_SSs]

Can you add the result (manually calculated) to that table and post it again so we can see what you are aiming for?
In particular I'm wondering about the 1st, 3rd and 4th examples where the 'Last' value is actually below the Annual Low.