You can create yourself a lookup table, and use the vlookup formula. See:
http://www.officearticles.com/excel/...soft_excel.htm
************
Anne Troy
www.OfficeArticles.com

"1image" wrote in message
...
Hi i'm creating a workbook to orginize stock, i'm not sure of how to
create a
table to give varying degress of discount according to the quatity bought
ie:
5 items or less = no discount, 6 to 11 items =2% discount and so on, i
have
used an if statement so far but i'm not sure how it is meant to work in
relation to the products and customers sheets, how does it all work
together.
Any help & guidence would be much appreciated.