Nesting Functions In Excel In last week’s tip I shown you how to create and use a simple IF Function Tips – Using the IF function in Excel. Today I shall explain the ‘Nested Function’. Nested means ...

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