1
1image
Hi, i'm trying to create a discount table in a workbook with 4 sheets
products, customers, discount, invoice. My problem is i'm not very
experienced and i'm not shore of how to write the formula. The discount
% i need Vlookup to calculate on the invoice refers to the amount of qty
purchased ie:
0<>6= 0% disc, 5<>11= 2% disc, there are five in total to calculate.
I have tried the If statement but when i use Vlookup to return the
value on the invoice it only shows 10% for all quantities. Can someone
pls show me how i would write the formula.
Many thanks in advance

products, customers, discount, invoice. My problem is i'm not very
experienced and i'm not shore of how to write the formula. The discount
% i need Vlookup to calculate on the invoice refers to the amount of qty
purchased ie:
0<>6= 0% disc, 5<>11= 2% disc, there are five in total to calculate.
I have tried the If statement but when i use Vlookup to return the
value on the invoice it only shows 10% for all quantities. Can someone
pls show me how i would write the formula.
Many thanks in advance
