How do I find the percentage between three numbers?

**Kaies** · 06-07-2013, 06:38 AM

It's a slow morning and I haven't had any coffee yet, so maths is something I'm having real trouble with.

Essentially, I have four columns.

	A	B	C	D
1	Current Stock	Min Stock	Max Stock	% In Stock
2	10	2	20	???
3	5	1	10	???

I want to know what percentage value Current Stock is if Min Stock is treated as 0% and Max 100%.
I cannot have any lower then Min Stock and I can't have any higher then Max Stock

I found a yahoo question which sounds exactly like what I want to do, however the answer was cryptic and I couldn't make any sense of it: http://ca.answers.yahoo.com/question...0172020AAlprmL

**Spitzerpl** · 06-07-2013, 06:48 AM

Do not trust my math! I just woke up and have not had a math class in years, but I think num/(max-min) is what you are looking for.

**Pete_UK** · 06-07-2013, 06:51 AM

So, you want:

Current_stock / (Max_stock - Min_stock)

i.e.:

=A2/(C2-B2)

formatted as percentage and copied down.

Hope this helps.

Pete

**martindwilson** · 06-07-2013, 06:52 AM

isnt it just current/ ((max-min)+1) ?

**XOR LX** · 06-07-2013, 06:52 AM

Hi,

I'm not sure how this is a question of finding a percentage between three numbers (what does that mean?) but this formula in D2 and copied down will give you what you want:

=(A2-B2)/(C2-B2)

Format cell as percentage.

Regards

**Kaies** · 06-07-2013, 07:22 AM

Originally Posted by XOR LX

Hi,

I'm not sure how this is a question of finding a percentage between three numbers (what does that mean?) but this formula in D2 and copied down will give you what you want:

=(A2-B2)/(C2-B2)

Format cell as percentage.

Regards

Thank you very much, this is exactly what I wanted! I'll mark this thread as solved.