View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Max Max is offline
external usenet poster
 
Posts: 9,221
Default Range Penetration - formula based on percentage

Another interp ..

If in A1: $20, in B1: $50,
then perhaps in C1:
=(B1-A1)*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