Formula for stochastic is (Last Number(x) - Lowest Low)/(Highest High - Lowest Low) * 100.
I want to find what is x when the answer is 0/100.
I can use this formula and fill in the x value with any number and slowly find the highest or lowest value for x.

I wonder if you can reverse the formula and put in the excel.

Said my working data is 1, 2, 3, 4, 5, x. To get 0, x is 1 and below. To get 100, x is 5 and above.

Thank you for your help.

This was put up yesterday, viewed 24 times but no reply yet.
HTML Code: