I would like to input two numbers being the max and min available amounts and
input a third number between those two and have it calculate the percentage.

EG.
input 1: 10 min
input 2: 20 max
input 3: 15
Calc: 50% - Calculated that box 3 is 50% between box 1 and 2.

"Killerwatt" wrote:

I would like to input two numbers being the max and min available amounts and
input a third number between those two and have it calculate the percentage.

EG.
input 1: 10 min
input 2: 20 max
input 3: 15
Calc: 50% - Calculated that box 3 is 50% between box 1 and 2.

Another eg.

Cell 1: is minimum price of $10
Cell 2: is maximum price of $20
We sold at
Cell 3: $15 was the selling price
Cell 4: Calculation that says cell 3 is 50% between the maximum and minimum
amounts.

Try this
cell 3 = 15
cell 2 = max
cell 1= min
15/(10+20) or =A3/(A1+A2)
and format the result cell to percentage

--
Browny


"Killerwatt" wrote:



"Killerwatt" wrote:

I would like to input two numbers being the max and min available amounts and
input a third number between those two and have it calculate the percentage.

EG.
input 1: 10 min
input 2: 20 max
input 3: 15
Calc: 50% - Calculated that box 3 is 50% between box 1 and 2.

Another eg.

Cell 1: is minimum price of $10
Cell 2: is maximum price of $20
We sold at
Cell 3: $15 was the selling price
Cell 4: Calculation that says cell 3 is 50% between the maximum and minimum
amounts.

Thanks Browny,

The problem is the amounts change and the Minimum is = to 0% and Max is = to
100% so that formula doesn't quite work.



"Browny" wrote:

Try this
cell 3 = 15
cell 2 = max
cell 1= min
15/(10+20) or =A3/(A1+A2)
and format the result cell to percentage

--
Browny


"Killerwatt" wrote:



"Killerwatt" wrote:

I would like to input two numbers being the max and min available amounts and
input a third number between those two and have it calculate the percentage.

EG.
input 1: 10 min
input 2: 20 max
input 3: 15
Calc: 50% - Calculated that box 3 is 50% between box 1 and 2.

Another eg.

Cell 1: is minimum price of $10
Cell 2: is maximum price of $20
We sold at
Cell 3: $15 was the selling price
Cell 4: Calculation that says cell 3 is 50% between the maximum and minimum
amounts.

Sorry Killerwatt,
i don't quite understand
--
Browny


"Killerwatt" wrote:

Thanks Browny,

The problem is the amounts change and the Minimum is = to 0% and Max is = to
100% so that formula doesn't quite work.



"Browny" wrote:

Try this
cell 3 = 15
cell 2 = max
cell 1= min
15/(10+20) or =A3/(A1+A2)
and format the result cell to percentage

--
Browny


"Killerwatt" wrote:



"Killerwatt" wrote:

I would like to input two numbers being the max and min available amounts and
input a third number between those two and have it calculate the percentage.

EG.
input 1: 10 min
input 2: 20 max
input 3: 15
Calc: 50% - Calculated that box 3 is 50% between box 1 and 2.

Another eg.

Cell 1: is minimum price of $10
Cell 2: is maximum price of $20
We sold at
Cell 3: $15 was the selling price
Cell 4: Calculation that says cell 3 is 50% between the maximum and minimum
amounts.