Looks kinda ugly, but

=(0.03*(MIN(A2,100000)))+(0.02*(MIN(900000,A2-(MIN(A2,100000)))))
+(0.01*(MIN(4000000,A2-(MIN(A2,100000))-(MIN(900000,A2-
(MIN(A2,100000)))))))+(0.005*(A2-(MIN(A2,100000))-(MIN(900000,A2-
(MIN(A2,100000))))-(MIN(4000000,A2-(MIN(A2,100000))-(MIN(900000,A2-
(MIN(A2,100000))))))))

On Jan 15, 3:32 pm, Scott - Key West <Scott - Key
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