Microsoft Excel Vlookup function to assign discounts based on difference between two dates

Using Vlookup, how do you apply a certain discount on fees based on how early an applicant pays. For example: offer a 10% discount if an applicant pays the fees one month before the class starts, 8% if he pays 3 weeks before, 5 percent if he pays one week before and nothing if he paid in the last week.

Category:

Howto & Style

Tags:

• Excel
• vlookup
• Microsoft
• Office
• Tutorial
• lookup
• function
• dates
• difference

[wog200]

i love you so much :) you helped me pass my assignment thank you sooooooooooo Muchhhhhhhhh damn tafe IT course =\

[hipchik1]

I enjoyed the tutorial, this is similar to what I am needing to do, but one question is, the fees are different as I have a column with different course types with different course fee amounts. So how do I use VLOOKUP to determine the discount for the different fees, using the scroll down? Or can it be done like that? I have 9 columns with the information and the 11th and 12th column is the table with delay days and %