All lessons

Nested formulas

30 min

Combine formulas inside one another to solve real finance problems.

Step 1 of 5

In this lesson

  • Formulas can live inside formulas
  • Excel works from the inside out
  • IFERROR cleans up lookups
  • Build step by step, then combine
Live practice sheet
ABCDEFGHI
1Order #Customer
21001Maya Chen
31002Liam O'Connor
41003Elena Vasquez
51004Noah Kim
61005Sofia Rossi
71006Aiden Patel
8
9
10Not on file
11
12
13
14

The highlighted cells show where this lesson's formula lives. Use the prompts on the left to rebuild it yourself.