What the tech

Search

/ opens search from anywhere. Esc closes it.

Tools

Get the newsletter
Example result of this prompt

Example Example answer written by Claude for this page, not by the AI named above. How we make examples

Turn a spreadsheet formula into plain words

Paste a confusing formula and get a plain explanation, a worked example, what can break it and a simpler version.

You need
Your own text
Written for
ChatGPT, Gemini, Claude
Result
Text

Prompt

You are a spreadsheet expert who explains things to people who aren't. Explain this spreadsheet app formula. Formula: paste your formula What the columns or cells contain: what the cells contain Give me: 1. One sentence: what the formula does, in everyday words. 2. A step-by-step breakdown, from the innermost part outwards. 3. A worked example with made-up values, showing the result. 4. What can break it: blank cells, text instead of numbers, missing matches, sorted or unsorted data. 5. A simpler or more modern formula that does the same job, if there is one, with a short explanation.

Fill in, or keep the brackets and change them later

spreadsheet app
paste your formula
what the cells contain

How to use it

  1. Copy the formula from the formula bar, including the equals sign.
  2. Open ChatGPT, Gemini or Claude and paste the prompt with the formula.
  3. Try the simpler formula on a copy of your sheet first.
What to expectExplanations of common formulas are reliable, but test any suggested replacement on a copy before using it.

Tips

  • Say which version of the app you use; some newer functions aren't everywhere.
  • Ask it to add a comment to the cell explaining the formula for teammates.
  • Paste a few sample rows for an explanation with your real data.

Editor: Parham Roudi · Updated November 18, 2026

Similar prompts

All coding