Try this formula to get the general logic. Then you can simplify it

=IF(A15000000,(A1-5000000)*0.5%+4000000*1%+900000*2%+100000*3%,IF(A1 1000000,(A1-1000000)*1%+900000*2%+100000*3%,IF(A1100000,(A1-100000)*2%+100000*3%,A1*3%)))

Tyro

"Scott - Key West" <Scott - Key wrote in
message ...
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