How to build nested functions in Excel

00:00 Avoiding nested functions in Excel
00:13 If you have to, best way to build nested formula in Excel
00:26 First nested formula example- formula split of cells based on delimiter
00:58 Safest way to combine Excel functions
01:15 Combining a FIND function inside a LEFT function
01:47 Copy the contents of the cell (NOT the cell)
01:58 Paste the FIND function within the LEFT function
02:27 Nest functions to extract the middle of a cell with uneven delimiters
02:55 Copy the contents of the first FIND cell & replace the cell reference in MID
03:16 Copy the contents of the 2nd FIND & replace the cell reference in MID
04:20 Rather use simple formulas- nested formulas as a last resort
04:35 Nested IF formula to determine scaled interest charges
05:00 VLOOKUP rather than nested IF
05:12 Draw a decision tree for your IF function first (NB)
05:46 Identify the separate IF functions
06:00 Build each IF separately, then combine them
06:17 Build the first IF function based on decision tree
06:41 Make the FALSE part of the IF a placeholder variable- we will use it later
07:08 Build the second IF function (ignore the complexity of 1st IF for now)
07:51 Now it is simple to turn the 2 IF functions into 1 nested IF function
08:17 Replace the 1st IF placeholder with the 2nd IF formula
09:10 Try avoid nested formula, otherwise use this technique to build safe nested formula in Excel

A simple technique to build complex, nested Excel functions by first building (and proving) the simpler components of the formula, and then combining them once you know they all work. This way you will avoid all the problems with unmatched parenthesis (brackets) and missing parts of a formula.