Microsoft Excel Vlookup function to assign discounts based o

Name: Microsoft Excel Vlookup function to assign discounts based o
Uploaded: 2009-02-17T09:16:29+00:00
Duration: 7 min 49 s
Channel: webiano
Description: 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.

webiano

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.

Recommended