Thread: 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" <1image@discussions.microsoft.com> wrote in message
news:EBB21404-A12F-4B9A-BD68-B949A735FF7F@microsoft.com...
> 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 <EBB21404-A12F-4B9A-BD68-B949A735FF7F@microsoft.com>,
1image@discussions.microsoft.com 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.
>