hi
based on what you said and your chart, this is how i interpeted......
=SUM(0.02*100000)+(0.02*900000)+(0.01*400000)+(0.0 05*5000000)

not sure but maybe it will give you ideas
Regards
FSt1

"Scott - Key West" wrote:

FEMA gives my city a percent of disaster grants for administrative costs,
based upon a tiered system related to the amount of the awards, and I've been
trying to figure a formula to determine these amounts.

Problem: The administrative costs awards are as follows:

3% on the first $100,000
2% of the next $900,000
1% of the next $4,000,000
.5% of everything in excess of $5,000,000

A figure of $6,000,000 ought to invoke all these percentages.

Any ideas