Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Percentage within a range
Within a row I have a static dollar range (two cells showing the min and max
of the range) and a third cell showing a dollar amounts that fall within that range. What I would like to see is what percentage the individual amount (cell 3) fall within the range (cell 1 and cell 2). For example - range is 26000 - 44000, and the single amount is 36000. Where does the 36000 fall percentage wise within that range? (not how much over the minimum, but where it lies in the range). Any assistance would be greatly appreciated! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Percentage within a range
What percentage do you want to calculate? The percentage of the minimum?
The percentage of the maximum? If the minimum is 100, your value is 150, and the maximum is 200, then 150 is 150% of the minimum and 75% of the maximum. Dave -- A hint to posters: Specific, detailed questions are more likely to be answered than questions that provide no detail about your problem. "Danielle" wrote: Within a row I have a static dollar range (two cells showing the min and max of the range) and a third cell showing a dollar amounts that fall within that range. What I would like to see is what percentage the individual amount (cell 3) fall within the range (cell 1 and cell 2). For example - range is 26000 - 44000, and the single amount is 36000. Where does the 36000 fall percentage wise within that range? (not how much over the minimum, but where it lies in the range). Any assistance would be greatly appreciated! |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Percentage within a range
Neither really --- this is salary data, and what we would like to see is
where an individual falls within the salary range -- maybe it is more of a percentile than percentage. In this example the spread in the range is 18000, we can see that the person falls in the range, but want to know what that specific point is -- make sense? "Dave F" wrote: What percentage do you want to calculate? The percentage of the minimum? The percentage of the maximum? If the minimum is 100, your value is 150, and the maximum is 200, then 150 is 150% of the minimum and 75% of the maximum. Dave -- A hint to posters: Specific, detailed questions are more likely to be answered than questions that provide no detail about your problem. "Danielle" wrote: Within a row I have a static dollar range (two cells showing the min and max of the range) and a third cell showing a dollar amounts that fall within that range. What I would like to see is what percentage the individual amount (cell 3) fall within the range (cell 1 and cell 2). For example - range is 26000 - 44000, and the single amount is 36000. Where does the 36000 fall percentage wise within that range? (not how much over the minimum, but where it lies in the range). Any assistance would be greatly appreciated! |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Percentage within a range
Yes, it sounds like a percentile rank question, not a percentage question.
To build a cumulative distribution, see he http://www.vertex42.com/ExcelArticle...ntileRank.html See also: http://www.techonthenet.com/excel/fo...percentile.php Lots more links here discussing the PERCENTILE function: http://www.google.com/search?hl=en&q...ntile+function Dave -- A hint to posters: Specific, detailed questions are more likely to be answered than questions that provide no detail about your problem. "Danielle" wrote: Neither really --- this is salary data, and what we would like to see is where an individual falls within the salary range -- maybe it is more of a percentile than percentage. In this example the spread in the range is 18000, we can see that the person falls in the range, but want to know what that specific point is -- make sense? "Dave F" wrote: What percentage do you want to calculate? The percentage of the minimum? The percentage of the maximum? If the minimum is 100, your value is 150, and the maximum is 200, then 150 is 150% of the minimum and 75% of the maximum. Dave -- A hint to posters: Specific, detailed questions are more likely to be answered than questions that provide no detail about your problem. "Danielle" wrote: Within a row I have a static dollar range (two cells showing the min and max of the range) and a third cell showing a dollar amounts that fall within that range. What I would like to see is what percentage the individual amount (cell 3) fall within the range (cell 1 and cell 2). For example - range is 26000 - 44000, and the single amount is 36000. Where does the 36000 fall percentage wise within that range? (not how much over the minimum, but where it lies in the range). Any assistance would be greatly appreciated! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Find a range of values in a range of cells | Excel Worksheet Functions | |||
LINKEDRANGE function - a complement to the PULL function (for getting values from a closed workbook) | Excel Worksheet Functions | |||
Wrap Text Across Columns & Rows | Excel Discussion (Misc queries) | |||
Duplicate Range Names by worksheet | Excel Discussion (Misc queries) | |||
Array to named range conversion... | Excel Discussion (Misc queries) |