Capstone: Refactor a Nested Commission Formula into LET and LAMBDA
This lesson is part of the course
In this lesson
You rewrite Alder & Finch's unreadable commission formula with LET, test a flat IFS version as an inline LAMBDA, and total the plan with MAP and the named function Commission, always with identical results.
Buy the course once for $9.99 to unlock every lesson and lab, the final exam and the certificate – lifetime access, no subscription.
Lessons in this course
- LET: Name Your Intermediate Results for Readable, Faster Formulas Locked
- LAMBDA Basics: Parameters, a Calculation and Calling It Inline Locked
- Named LAMBDAs: TaxPrice, MarginPct and Your Own Workbook Functions Locked
- BYROW and BYCOL: One Formula for Every Row or Column Locked
- MAP: Your Own Logic for Every Element, Even with AND and OR Locked
- REDUCE and SCAN: Running Totals, Compounding and Final Balances Locked
- MAKEARRAY: Multiplication Tables, Rotas and Payment Schedules Locked
- Capstone: Refactor a Nested Commission Formula into LET and LAMBDA Locked