πŸ’¬ Use The Onion Method To Approach Complex Formulas

Replied to Use The Onion Method To Approach Complex Formulas (Ben Collins)

If you’re building complex formulas, then I advocate following a one-action-per-step approach.


What I mean by this is that you build your formulas in a series of steps, and only make one change with each step.


The Onion Method is a framework by which to approach hard formulas, and consists of these three elements:

  1. Put each new step of the formula in a new cell
  2. Label each step with a simple β€œStep 1”, β€œStep 2”, etc. in adjacent cells
  3. Change the background color of each formula cell, so they can be easily found
I love the way you breakdown complex examples using the onion method through all your courses.

2 responses on “πŸ’¬ Use The Onion Method To Approach Complex Formulas”

Leave a Reply

Your email address will not be published. Required fields are marked *