Download Excel File: https://excelisfun.net/files/EMT1643.xlsx
Learn how to calculate a series discount to calculate cost that then can be multiplied by units to get Total Invoice Amount. See 4 methods. Two multi-cell solutions and two single cell solutions. Learn about the Excel Functions: VLOOKUP, IF, XLOOKUP, PRODUCT, INDEX and MATCH.
1. (00:01) Introduction
2. (00:37) XLOOKUP Solution
3. (05:38) VLOOKUP solution
4. (05:55) Single Cell XLOOKUP Solution
5. (07:15) Single Cell INDEX Solution
6. (08:27) Summary and End Video Links