Fixed Percentage Calculation

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Dot - 05 Mar 2008 15:18 GMT

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

Reply to this Message

Rick Rothstein (MVP - VB) - 05 Mar 2008 15:36 GMT

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

>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

Reply to this Message

Dot - 05 Mar 2008 16:13 GMT

That appears to answer the question. Thanks alot Rick

> If your values are assigned to cells like this...
>
[quoted text clipped - 16 lines]
> > in a cell how would I create a formula to tell me what percentage it is in
> > this range

Reply to this Message