How to Explain a Spreadsheet Formula in Plain English and Fix It When It Breaks

Gather three ingredients and make a test copy

Click the cell with the broken formula. Its text appears in the formula bar, the long box above the grid of cells. Copy that text. Next, pick three to five rows that show the inputs and the result you expected. Copy those values too, and write the expected answer next to each row. Finally, copy the exact error you see, such as #N/A or #VALUE!, or describe what the cell shows.

Before you share anything, replace real names, account numbers, addresses and other personal details with placeholders like "Customer A" or "Account 1." Then make a copy of the whole file. Look for "Make a copy" or "Save as" under the File menu. Work on that copy from now on.

Next step ↓

Ask for a piece-by-piece breakdown

Open a new chat with your AI assistant. Paste your instructions in plain sentences. Asking for a piece-by-piece explanation works better than asking "what does this do?" because you get each part explained in order. Look at the reply. You should see a short explanation for each function, such as "this part looks up a value" or "this part adds numbers together." If the assistant uses a word you don't know, such as "argument" (the input a function needs), ask it to explain that word in one sentence.

Next step ↓

Ask for the likely cause of the error

Stay in the same chat so the assistant keeps the context from Step 2. Now ask for diagnosis, not a fix yet. Give it the error and the sample rows, including the rows that work and the ones that don't. Most formula errors come from a few common causes: a reference pointing at the wrong column, numbers stored as text, extra spaces, or a range that doesn't cover the rows you need. Ask the assistant to rank its guesses and tell you how to check each one yourself.

If the answer sounds certain but doesn't match your file, that's a warning sign. Reply with what you actually see in one cell, and ask it to recheck.

Next step ↓

Ask for one corrected version and a plain explanation

Now ask for the fix. Ask for only one corrected formula, and ask the assistant to explain what changed in plain words. Plain-language explanations are the part most people skip, and they matter. If you can't say why the new formula is different, you can't tell whether it is right. Also remind the assistant what the cell should show, so it doesn't optimize for something else.

If the assistant gives you several versions or skips the explanation, reply: "Give me only one version, and explain each change in one sentence."

Next step ↓

Test the fix on your copy

Paste the corrected formula into one cell in your copy file, on the row you used as a sample. Compare the result with the expected answer you wrote down in Step 1. If it matches, copy the formula down to a few more rows and check those too. Look for rows that are unusual, such as blank entries or very large numbers, because those often reveal problems that the sample rows didn't.

If the result is still wrong, don't just try again. Tell the assistant exactly what happened, in the same chat. This back-and-forth is called iteration, which simply means improving an answer by giving feedback on each round.

Next step ↓

Save your instructions for next time

Once a prompt works, you shouldn't have to rebuild it from scratch. Copy your best prompt and a short template into a note on your phone or computer. Then look in your assistant's settings or sidebar for a place to save standing instructions, or a "projects" area for recurring work. Many assistants offer something like this, but the names and locations vary, and some options may need a paid plan.