| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Fixed & Reducing Balance Loan Calculation. | Excel Discussion (Misc queries) | |||
| fixed cell in formula calculation | Excel Worksheet Functions | |||
| What calculation can I use to find income on a fixed investment? | Excel Discussion (Misc queries) | |||
| how do i enlarge a pie chart by a fixed percentage? | Charts and Charting in Excel | |||
| Fixed Duration-strange calculation | New Users to Excel | |||
Linear Mode
