ExcelBanter - Fixed Percentage Calculation

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Fixed Percentage Calculation (https://www.excelbanter.com/excel-worksheet-functions/178851-fixed-percentage-calculation.html)

dot

Fixed Percentage Calculation

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

Rick Rothstein $MVP - VB$[_135_]

Fixed Percentage Calculation

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

"Dot" wrote in message
...
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

dot

Fixed Percentage Calculation

That appears to answer the question. Thanks alot Rick

"Rick Rothstein (MVP - VB)" wrote:

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

"Dot" wrote in message
...
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

All times are GMT +1. The time now is 12:31 PM.