Range Penetration - formula based on percentage
My take would be if your "range" is $20-50, 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
=(A2-A1)*.7 would give you the $21, and
=(A2-A1)*.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
|