Discount table

  • Thread starter Thread starter Kanga
  • Start date Start date
K

Kanga

As part of an assessment I have to create a discount table to show 0-4
sales attract 0% discount, 5-10 sales attract a 2% discount, 11-20
sales attract an 5% discount and so on. I created a simple table with 2
columns - the first column has the numbers 0, 5,11 and 21. And a second
column with 0%, 2%, 5%, 8%. In another worksheet I created a VLOOKUP
function to find the appropriate discount
=VLOOKUP(D19,Discount!A3:B7,2,TRUE) - and it works! But the teacher
states that it is close but will not work correctly - the values in
column 1 are the change points - 0,5,11,21 Column 2 contains the
discount - try again. What have I done wrong?
Update: This is the table
=VLOOKUP(D19,Discount!A3:B7,2,TRUE)
Purch Discount
0 0%
5 2%
11 5%
21 8%
51 10%
Can you help me? Why did the teacher say it isn't correct?
 
Nothing wrong as far as your VLOOKUP set-up is concerned.
Take it that the VLOOKUP cells are formatted as percentages.
 
so, given the insights from us, what's the verdict from your teacher ?
do post back in this thread to let us know. cheers.
 
Back
Top