Percentage of cell depending on value of another cell Excel 2003

[htevents]

Hello All,

after your wonderfull help with another thread, I'd like to ask another question:

I have a sheet where I calculate the total price of some products, but some products qualify for discount, others do not, but the total price determines the percentage of discount of the product that qualify.

What I want is to have a cell with the total price of the products (have it already) and a cell with the variable discount percentage. The cell wilth the percentage should be based on the value in the cell with the total price, so the cell should have the following percentages:
(lets say cell B11 is the cell with the total price and cell C11 is the percentage cell)

When B11 is less then €49,99, cell C11 should be 10%
When B11 is between €50 and €99,99, cell C11 should be 15%
When B11 is between €100 and €249.99, cell C11 should be 20%
etc. etc. etc.

 

[htevents]

Never mind, got it already.

=IF(T15<50;0,1;IF(T15<100;0,15;IF(T15<250;0,2;IF(T15<500;0,25;IF(T15>500;0,3)))))

Set your cell format to percentage.

 

[FDibbins]

Another way would be to set up a small table to contain the ranges and percents, and then use vlookup()