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

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
From:
ExcelIsFun
Views:
3724

7
ratings
Time:
12:27
More in
Science & Technology