Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
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. |
#3
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conversion of Cross-Tab Formatted data to qualify for Pivot Table | Excel Discussion (Misc queries) | |||
How do I create a one variable data table? | Excel Discussion (Misc queries) | |||
How do I create a pivot table if the pivot table icon or menu ite. | Charts and Charting in Excel | |||
create space in line chart between points, linked to pivot table | Charts and Charting in Excel | |||
How can I create a table of contents(worksheets) for a large work. | Excel Discussion (Misc queries) |