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