How to create a table to qualify a qty discount in exel
 

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.

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.

See Chip Pearson's http://www.cpearson.com/excel/pricing.htm.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article ,
says...
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.