trying to solve an if formula in excel

Hi All, I would really appreciate a solution to an if function that I am having trouble with,

If the Qty is less than 5 then the Disc% is 0%
If the Qty is between 5 and 9 inclusive then the Disc% is 2%
It the qty is 10 or greater then the Disc% is 5%

here is what i am using! IF(D8<5,0%,IF(D8=5,2%,IF(D8=6,2%,IF(D8=7,2%,IF(D8=8,2%,IF(D8=9,2%,IF(D8>=10,5%)))))))

is there another way to do this particulary for the qty between 5 and 9. thanks in advance, appreciate any help!

Thanks for your quick response Ace_xl, that was quick, have one other lookup problem but its hard to explain. really appreciate your help, new to spreadsheet for now!

Trying to use lookup to calculate the cost price, any ideas would be gratefully received!

Item Description Cost Price Selling Price Qty Disc% Disc Allowed New Selling Price Total

Computer Type 1 2 3 4 5
Cost Price 580 620 650 720 760
Printer DM 9 €- 13 5% €- €- €-
Printer DM 24 €- 6 2% €- €- €-
Printer IJ1 €- 15 5% €- €- €-
Printer IJ2 €- 8 2% €- €- €-
Printer L1 €- 6 2% €- €- €-
Printer L2 €- 9 2% €- €- €-
Plotter A4 €- 4 0% €- €- €-
Plotter A3 €- 3 0% €- €- €-
Disk DD(Box 10) €- 22 5% €- €- €-
Disk HD (Box 10) €- 18 5% €- €- €-
1 Subtotal €-
2 Vat= 21% €-
3 Total Inc VAT €-
4
5

that didnt work out ah well

trying again
Item Description Cost Price Selling Price Qty Disc% Disc Allowed New Selling Price Total

Computer Type 1 2 3 4 5
Cost Price 580 620 650 720 760
Printer DM 9 € - 13 5% € - € - € -
Printer DM 24 € - 6 2% € - € - € -
Printer IJ1 € - 15 5% € - € - € -
Printer IJ2 € - 8 2% € - € - € -
Printer L1 € - 6 2% € - € - € -
Printer L2 € - 9 2% € - € - € -
Plotter A4 € - 4 0% € - € - € -
Plotter A3 € - 3 0% € - € - € -
Disk DD(Box 10) € - 22 5% € - € - € -
Disk HD (Box 10) € - 18 5% € - € - € -
1 Subtotal € -
2 Vat= 21% € -
3 Total Inc VAT € -
4
5

Jamie
Its hard to understand your data as its difficult to line it up in tabular form when
displayed as text. Can you attach a spreadsheet with the data lined up properly ?