Create formulas for calculations

Create formulas for calculations in Microsoft Excel — with the four heights of help laid out: do it now, make it easier for the next person to accept, work out the right move when you are stuck, and learn the pattern so it stops coming back.

4prompt heights
Open it in the interactive atlas →

The four heights

The same task, four distances: today's deadline, the next reviewer, the stuck moment, the pattern.

Execute — do the immediate task

+
Build formulas that calculate gross margin percent for each product row using the existing Revenue…
Build formulas that calculate gross margin percent for each product row using the existing Revenue and Cost columns. Use row 5 as the first example and copy down to row 250. Ensure the formula returns a blank if Revenue is blank, and format the result as a percentage with one decimal place.

Improve — make it easier to accept

+
Before I circulate the model, make the margin calculations reviewer-friendly. Put the gross margin…
Before I circulate the model, make the margin calculations reviewer-friendly. Put the gross margin percent near the price columns, use an IF to hide division errors and blanks, add a brief comment explaining the formula logic on the header, and highlight any margins below 20 percent.

Decide — diagnose the stuck moment

+
I added a gross margin percent formula referencing Revenue and Cost and now several rows show…

I wrote a margin formula and some cells show #DIV/0! while others show 100% unexpectedly.

I added a gross margin percent formula referencing Revenue and Cost and now several rows show division errors or 100% even though the numbers seem wrong. I don't know whether the formula references are wrong or if zeros are in the revenue cells. What checks should I run in order to diagnose the cause quickly and fix the formulas so they behave when revenue is missing?

Become — change the pattern

+
Across multiple models I keep rebuilding formulas after columns are moved or blank values are…

My sheets frequently break when source columns change order or blank values appear.

Across multiple models I keep rebuilding formulas after columns are moved or blank values are introduced; it eats time and undermines trust in my sheets. Which routine practices will make formulas resilient so they survive column reorders and sparse data without constant fixes?

Next to this one

Other spreadsheet work people do in Microsoft Excel.

Every task here came from the work, not from a feature list — which is why the prompts name what you want done and never the button that does it. The tool changes; the work does not.
Copyright © LLOS.ai · 2026 — original pedagogy, voice, and design — all rights reserved.

The rest of the map

Same library, five ways in.