Microsoft Excel has hundreds of built-in functions, but even those don't cover every need. Here's how to use LAMBDA to easily create custom functions.

The SWITCH statement in Excel is a relatively new function. It takes an expression and tests it against multiple outcomes in a more readable and structured format compared to nested IF statements.

We’ll start with three easy IF statements, then move on to nested IF statements and multi-function IF statements. At the end we’ll get fancy with COUNTIF, SUMIF, AVERAGEIF, and IF with wildcards.