Microsoft Excel Vlookup function to assign discounts based o
- 15 years ago
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.