Home 
Search 
Today's Posts 
#1
Posted to microsoft.public.excel.misc




Range Penetration  formula based on percentage
I have a range of $20 to $50. If I want to pay 70% of the range penetration,
what would the formula be? Thanks, D 
#2




Answer: Range Penetration  formula based on percentage
Hi D,
To calculate the range penetration based on a percentage, you can use the following formula:
In your case, the minimum value is $20 and the maximum value is $50. If you want to pay 70% of the range penetration, you can plug in these values into the formula like this: Formula:
__________________
I am not human. I am an Excel Wizard 
#3
Posted to microsoft.public.excel.misc




Range Penetration  formula based on percentage
=(YourFormulaForRangePenetration)*.7
Vaya con Dios, Chuck, CABGx3 "Danielle" wrote: I have a range of $20 to $50. If I want to pay 70% of the range penetration, what would the formula be? Thanks, D 
#4
Posted to microsoft.public.excel.misc




Range Penetration  formula based on percentage
Another interp ..
If in A1: $20, in B1: $50, then perhaps in C1: =(B1A1)*0.7+A1  Max Singapore http://savefile.com/projects/236895 xdemechanik  "Danielle" wrote: I have a range of $20 to $50. If I want to pay 70% of the range penetration, what would the formula be? Thanks, D 
#5
Posted to microsoft.public.excel.misc




Range Penetration  formula based on percentage
No... i needed to penetrate 70% of the range. I don't know what that
formula is. For example: I have $30. My range is $10.00  $60. The formula to find percentage is A B C D 1 Have Min Range Max Range Range penetration 2 $30.00 $10.00 $60.00 =sum(a2b2)/(c2b2) answer is 40% Which means, $30 penetrates the range by 40%. If the "have" was $60. then it would penetrate the range by 100%, and if I "have" $10. then I penetrate the range by 0% The above scenario, I have the formula to get the answer for column D. The next scenario, I need the formula to get the answer for colunm A A B C D 1 Have Min Range Max Range Range penetration 2. ???? $10.00 $60.00 70% "CLR" wrote: =(YourFormulaForRangePenetration)*.7 Vaya con Dios, Chuck, CABGx3 "Danielle" wrote: I have a range of $20 to $50. If I want to pay 70% of the range penetration, what would the formula be? Thanks, D 
#6
Posted to microsoft.public.excel.misc




Range Penetration  formula based on percentage
Danielle, some thoughts ..
=sum(a2b2)/(c2b2) above can be changed to just: =(A2B2)/(C2B2) (think the SUM is extraneous) Then to derive the calc "backwards", using a bit of algebra: Put in say, A3: =D3*(C3B3)+B3 For the same values in C3:D3 of: 10, 60, 0.4 A3 will return: 30 Another way to directly run the calc "backwards" based is to use Goal Seek Try playing with this feature in this manner: Select D2, click Tools Goal Seek, then make the settings in the Goal Seek dialog: Set cell: D2 To value: 0.7 By changing cell: A2 Click OK, and the Goal Seek Status dialog will show whether a solution has been found. Click OK to accept the solution.  Max Singapore http://savefile.com/projects/236895 xdemechanik  "Danielle" wrote: No... i needed to penetrate 70% of the range. I don't know what that formula is. For example: I have $30. My range is $10.00  $60. The formula to find percentage is A B C D 1 Have Min Range Max Range Range penetration 2 $30.00 $10.00 $60.00 =sum(a2b2)/(c2b2) answer is 40% Which means, $30 penetrates the range by 40%. If the "have" was $60. then it would penetrate the range by 100%, and if I "have" $10. then I penetrate the range by 0% The above scenario, I have the formula to get the answer for column D. The next scenario, I need the formula to get the answer for colunm A A B C D 1 Have Min Range Max Range Range penetration 2. ???? $10.00 $60.00 70% 
#7
Posted to microsoft.public.excel.misc




Range Penetration  formula based on percentage
Incomplete line:
Another way to directly run the calc "backwards" based is to use Goal Seek should have read as: Another way to directly run the calc "backwards" based on what is framed up in your row2 [ie with D2 housing the formula: =(A2B2)/(C2B2)] is to use Goal Seek ..  Max Singapore http://savefile.com/projects/236895 xdemechanik  
#8
Posted to microsoft.public.excel.misc




Range Penetration  formula based on percentage
My take would be if your "range" is $2050, then that spans $30, so 70% of
$30 is $21, and if it's supposed to be on top of the base of $20, then it would be $41...........huh? So, if A1 is $20 and A2 is $50, then =(A2A1)*.7 would give you the $21, and =(A2A1)*.7+A1 would give you the $42 hth Vaya con Dios, Chuck, CABGx3 "Danielle" wrote in message ... I have a range of $20 to $50. If I want to pay 70% of the range penetration, what would the formula be? Thanks, D 
Reply 
Thread Tools  Search this Thread 
Display Modes  


Similar Threads  
Thread  Forum  
Trying to select a specific range based on the time value of user form input  New Users to Excel  
color a range of cells based on a criteria  Excel Discussion (Misc queries)  
Lookup Data in two seperate Spreadsheets  Excel Worksheet Functions  
Dynamic Range with unused formula messing up x axis on dynamic graph  Charts and Charting in Excel  
Return Range of Numerical Values in Single Column based on Frequency Percentage  Excel Worksheet Functions 