LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
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

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
i know this is simple, but driving me nuts - formula [email protected] Excel Worksheet Functions 2 May 2nd 06 08:22 PM
Need Help, this is driving me nuts heitorfjr Excel Discussion (Misc queries) 2 January 15th 06 03:10 PM
question driving me nuts Esaam New Users to Excel 4 December 6th 05 05:34 AM
Sum and Count are driving me nuts!! Mattrapps Charts and Charting in Excel 1 May 9th 05 07:08 PM
Driving me nuts. Need more nested than 7 Stressed Excel Discussion (Misc queries) 5 April 12th 05 06:20 PM


All times are GMT +1. The time now is 11:27 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"