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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Test records from one table / query against a date range in another table 2
Create Discout Table 5
How To Create a Percentage Discount in Invoice 5
How to put a Calculated Value in a Field? 1
using dlookup to automatically fill in the discount rate in a form 1
How do I add a Discount facility in the Time & Billing Database? 4
Using check boxes in a form to be criteria in a query 1
Access Scan a UPC on a txtfield on mainform & add to subform Please Help! 1

Back
Top