excel formula
Project details
I need a fairly simple excel formula. I want to insert an income amount. From that entry, I need the formula to calculate a percentage of the amount in a tiered format. IE. I enter $1,000,000. The tiers would be as follows: 0 – 250,000 = 6%, 250,001 – 500,000 would be 5%, 500,001 – 750,000 would be 4%, and 750,001 to 1,000,000 would be 3%. Anything over 1,000,000 would be 0 as 1 mil would be the cap. Then I need these totals to be calculated into one total amount. If I enter 1,000,000 or more the amount would be 45,000: 6% of the first 250K = 15,000, 5% of the next 250K = 12,500, 4% of the next 250K = 10,000 and the last 250K = 7500 for a total of 45,000. Thanks
Awarded to:
Ammara H.
(5.0)
Awarded to:
Ammara H.
(5.0)
Project details
skills of Ammara H.
skill ^{?}  level ^{?}  projects ^{?}  

Charts 
40%

3  
35%

3  
Word 
35%

3  
Infographics 
35%

3  
Data Entry 
34%

7  
Data Processing 
34%

3  
Excel 
34%

10  
English (US) Translator 
34%

3  
Translation 
34%

3  
Data Analysis 
34%

1  
Data Analytics 
34%

1  
Data Science 
34%

1  
Data Visualization 
34%

1  
Data Warehousing 
34%

1  
Data Mining 
34%

1 
Some Ammara H. projects
Project Title  Skills required in the project 

Excel Formulas and Conditional Formatting/VLookup  Data Entry Data Processing Excel Visual Basic 
Simple Excel Macro to copy columns and format text  Data Entry Data Processing Excel Excel Macros Visual Basic 
Word Document merge fields from Excel File  Data Entry Data Processing Excel PDF Word 
Create a graph  Charts English (US) Translator Excel Infographics Translation 
excel formula  Data Entry Excel 