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...
Vlookup Date Picker in Excel (Dynamic)
Tutorial: Make a dynamically updating vlookup date picker for excel that allows you to choose a date...
Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course



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.