Excel Formula to calculate a percentage depending on the dollar amount added into a cell.?

I am needing to get an excel formula to calculate a different percentage depending on the dollar amount added into the cell. Ex.

if the dollar amount is between $0 and $299 I need it to calculate 0%, if between $300 and $399 to calculate 10%, if between $400 and $499 to calculate 18%, if between $500 and $599 to calculate 25% and equal to or greater than $600 to calculate 30%. Any help will be greatly appreciated.

ThanksExcel Formula to calculate a percentage depending on the dollar amount added into a cell.?
If the dollar amount is entered in C1, enter this formula where you want the answer.



=(C1*LOOKUP(C1,{0,300,400,500,600;

0,0.1,0.18,0.25,0.3}))+C1



This adds the percentage to the amount in C1.



If you don't want the total but just the dollar amount that the percentage represents then this is the formula.



=LOOKUP(C1,{0,300,400,500,600;0,0.1,0.鈥?br>


If you have a column of dollar amounts, this can be entered at the top of the column and dragged down the length of your data.



The C1 in the formula can be changed to the cell reference where your dollar amount it.