Fixed Percentage Calculation

D

Dot

I have a fixed range. e.g. $55,000=85% and $80,000=115%. If I put $63,000
in a cell how would I create a formula to tell me what percentage it is in
this range
 
R

Rick Rothstein \(MVP - VB\)

If your values are assigned to cells like this...

P1: 85%
P2: 115%
Q1: 55000
Q2: 80000
V1: 63000

then the formula to calculate the percentage you seek is this...

=P1+(V1-Q1)*(P2-P1)/(Q2-Q1)

To help you follow the cell assignments I used, think Q for quantity, P for
percentage and V for value.

Rick
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Percentage Increase 11
Percentage of Weight Loss/Gain 4
How do I use a percentage formula? 2
Help with calculating tax percentages 2
Returning a value from a range 1
Needs help combining functions. 3
Not having luck with any examples of averaging... 2
Calculating an average of data between two dates 1

Top