View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Scott - Key West Scott - Key West is offline
external usenet poster
 
Posts: 1
Default Driving me nuts trying to figure this formula

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