On Sat, 9 Aug 2008 08:37:27 -0700, Natalie John
wrote:

Here are the requirements

I need one answer with different parameters within one formula

If amount is less than or equal to 100 then answer will be Zero
If amount is more than 100 but less than or equal to 150 then answer will be
8% of the amount exceeding 100
If amount is more than 150 but less than or equal to 300 then answer will be
25 + 12% of the amount exceeding 150
If amount is more than 300 but less than or equal to 400 then answer will be
50 + 20% of the amount exceeding 300
If amount is more than 400 but less than or equal to 700 then answer will be
75 + 25% of the amount exceeding 400
If amount is more than 700 then answer will be 100 + 35% of the amount
exceeding 700

If your amount is in cell A1, try this formula in the cell where you
want you answer

=LOOKUP(A1,{-999,100,150,300,400,700},{0,0,25,50,75,100})+(A1-LOOKUP(G5,{-999,100,150,300,400,700}))*LOOKUP(A1,{-999,100,150,300,400,700},{0,0.08,0.12,0.2,0.25,0.3 5})

Note: -999 is just a number which is less that the minimum possible
amount. The other numbers all come from you description.

Hope this helps / Lars-Åke