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(a2-b2)/(c2-b2)

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