Microsoft Excel Vlookup function to assign discounts based o

1

webiano

2011-06-01T09:17:38-0400

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.

ExcelvlookupMicrosoftOfficeTutoriallookupfunctiondatesdifference