Help with finding the position of a value as a percentage

[SamuelVile18]

Hi all...I have a query that I'm struggling with, I'm not too sure if I'm going too technical too quickly tbh!

I have some values laid out in a table similar to below, I need a formula that can automatically calculate the position of the value in % form.

Min	Max	Value	Position %
50	100	75	50%
10	30	20	50%

I cannot figure it out. The formula needs to find where the value sits between the min and max values - then return that as a percentage.

Is this even possible?

 

[RoryA]

It's basically =(value-min)/(max-min) and format as a percentage.

 

[Fluff]

Hi & welcome to MrExcel.
How about

+Fluff 1.xlsm
	A	B	C	D
1	Min	Max	Value	Position %
2	50	100	75	50%
3	10	30	25	75%
Main

Cell Formulas
Range	Formula
D2:D3	D2	=(C2-A2)/(B2-A2)

 

[SamuelVile18]

I knew I was being an idiot and looking for the most technical answer straight away...thank you very much for your help, saved me losing my temper for no reason!

 

[Fluff]

Glad we could help & thanks for the feedback.