How do I Calculate a percentage
"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.
|