Discount table

Nothing wrong as far as your VLOOKUP set-up is concerned.
Take it that the VLOOKUP cells are formatted as percentages.

Kanga wrote in message
...
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?

Kanga-

I agree with Max. I am not seeing any errors on your part.

--
Laura Cook
Appleton, WI


"Kanga" wrote in message
...
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?



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/