Formula for sliding scale calculations
 

I'm stumped (and embarrased). I can't figure out how to insert a fee formula
that will take a total project value and charge a percentage based on a
sliding schedule:

Project Value: $250,000

Rate Fee
Fee Schedule: First $50,000 5% _____
$50,001 - $200,000 4% _____
$200,001+ 3% _____
TOTAL FEE: $0.00

Formula for sliding scale calculations
 

To calculate total fee:

=MIN(A1,50000)*5%+MIN(MAX(IF(A1200000,200000,A1)-50000,0),200000)*4%+MAX(A1-200000,0)*3%

If you want the individual parts, simply break the formula down into its 3
sections.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Lyn" wrote:

I'm stumped (and embarrased). I can't figure out how to insert a fee formula
that will take a total project value and charge a percentage based on a
sliding schedule:

Project Value: $250,000

Rate Fee
Fee Schedule: First $50,000 5% _____
$50,001 - $200,000 4% _____
$200,001+ 3% _____
TOTAL FEE: $0.00