VLookup

[evilwizard]

im having some troubles working out this for my course

i have attached the .xls doc

At the beginning of the term our staff is busy with enrolments. Students are given a discount if they pay the course fee in advance. The staff needs to calculate and record the course fees paid by students. To make this task easier for our staff you will need to design a template which can be re-used each term. Include appropriate headings.

You should create and enter formulas to calculate the No. of Days paid in Advance, the Discount and the Course Fee Paid.

Use a VLOOKUP function in your template to determine the discount rate to be used for the calculation of the Discount. Your template should include a separate discount table containing the following information about the discount received:

•If students pay the course fee less than 7 days prior to the course commencing then they receive no discount.

• If students pay the course fee 7 to 13 days prior to the course commencing then they receive a discount of 5%.

• If students pay the course fee 14 to 20 days prior to the course commencing then they receive a discount of 8%.

• If students pay the course fee 21 days or more prior to the course commencing then they receive a discount of 10%.

[teylyn]

Is this homework? This sounds like an assignment task. We don't do homework.

But as a pointer: you need to set up a lookup table with the "days early" in one column and the discount % in the adjacent column.

Then have a look at Vlookup(), especially with True as the last parameter. Or, alternatively, Lookup().

[evilwizard]

yeah m8 is a assignment , i have never used excel b4 , really need help with it i really didnt understand it but thank you for your pointer