ReePrime
Microsoft Excel Vlookup function to assign discounts based o

Hosted by Dailymotion. For legal issues report at the Copyright Center, report us on DMC, or use the Instant Removal tool.

Microsoft Excel Vlookup function to assign discounts based o

W
webiano

1 Views • Feb 17, 2009

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.