Microsoft Excel Vlookup Function to Assign Discounts Based on Difference Between Two Dates

Tags:
Microsoft Excel Vlookup Microsoft Offices Tutorials Lookup Function Dates Difference
Webiano
  • By: Webiano
  • Subscribers: 0
  • Updated: 17-Feb-09
  • Videos: 1
  • International English
  • Comments: 0
  • Views: 541
  • Added: 17-Feb-09

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.

  1. Categories: How To, Science & Tech
Comments on

Microsoft Excel Vlookup Function to Assign Discounts Based on Difference Between Two Dates

0 Comments | Be the first to comment