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