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!
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 | |