Formula for sliding scale calculations

[Lyn]

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

 

[Luke M]

To calculate total fee:

=MIN(A1,50000)*5%+MIN(MAX(IF(A1>200000,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.