Excel Forum
Similar Content
Excel Data Validation - Limit What a User Can Enter into a Cell
Tutorial: Data Validation is a tool in Excel that you can use to limit what a user can enter into a...
Remove All Data Validation from a Cell in Excel
Macro: Remove all data validation from a cell in Excel with this free Excel macro. This is a grea...
How to Use the IF Function in Excel
Tutorial: The IF statement is a simple yet powerful tool. Today we will go through how the IF functi...

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.