View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Killerwatt Killerwatt is offline
external usenet poster
 
Posts: 3
Default 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.