Excel Forum

Excel Magic Trick 628: VLOOKUP Data Validation IF Function Date Math Total After Discount Template

Great Excel Basics to Intermediate Video:
1. VLOOKUP to look up a price for a student course -- using Exact Match
2. VLOOKUP to look up a discount rate for days paid early -- Using Approximate Match
3. Date Math Formula to figure out the number of days the fee was paid early
4. IF function to hide a formula when it delivers an error in a template.
5. Formula for discount for paying early
6. Formula for total amount due after discount

Got a Question? Ask it Here in the Forum.