# Help with finding the position of a value as a percentage

#### SamuelVile18

##### New Member
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?

### Excel Facts

Bring active cell back into view
Start at A1 and select to A9999 while writing a formula, you can't see A1 anymore. Press Ctrl+Backspace to bring active cell into view.
It's basically =(value-min)/(max-min) and format as a percentage.

Hi & welcome to MrExcel.
+Fluff 1.xlsm
ABCD
1MinMaxValuePosition %
2501007550%
310302575%
Main
Cell Formulas
RangeFormula
D2:D3D2=(C2-A2)/(B2-A2)

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!

Glad we could help & thanks for the feedback.

Replies
3
Views
197
Replies
19
Views
348
Replies
3
Views
98
Replies
2
Views
180
Replies
3
Views
68

1,196,503
Messages
6,015,586
Members
441,903
Latest member
MG12345

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

### Which adblocker are you using?

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

### Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back