You know the business rule: gross margin is profit divided by revenue. The part you've forgotten is the syntax, whether it needs IFERROR or IF, or what the formula should do with a blank or zero. Copilot can write the formula from a sentence. It can also classify customer comments and carry out a checklist of workbook edits. Your job is to leave a clear trail from the request to a result you can test.
Copilot can enter formula work in three different ways. Identify which one you're using before you accept the result:
Deterministic work belongs in ordinary Excel formulas. Totals, percentages, and date differences need to recalculate and remain explainable. Use generated content for language tasks.
A formula records a business definition. Change the denominator and you change the metric. With revenue of 1200 and cost of 720, profit is 480. Profit divided by revenue gives a 40% margin. Profit divided by cost gives roughly 66.7% markup. Both describe profitability, but they aren't interchangeable. If the request says only "calculate profitability," Copilot has to choose the denominator. Name the metric and the denominator yourself.
Include the result and its definition, source columns, row or range context, and the expected treatment of blanks, zeros, and errors. Say whether you want only the formula or an explanation as well. Structured references keep the formula readable: inside a table, [@Revenue] means "Revenue in this row," so =([@Revenue]-[@Cost])/[@Revenue] exposes the calculation without cell coordinates. Also distinguish an empty cell from a formula that returns "". The latter looks blank but contains a formula, which means ISBLANK returns FALSE. If a later calculation must treat it as empty, test for ="".
The COPILOT function is for language, not arithmetic
The =COPILOT() worksheet function doesn't perform an Excel calculation. It sends an instruction and cell context to Copilot, then places generated content in the cell. For example, =COPILOT("Classify this comment as Positive, Neutral, or Negative. Return exactly one label.", E2) reads the comment in E2. Down a column, the function can classify, summarize, extract, or rewrite text.
Give it a closed set of allowed outputs and ask for exactly one result. Without that constraint, the cells may contain punctuation, explanations, or labels you didn't request. Review the answers as well. "Good product, but support was slow" calls for judgment, so a person should read borderline cases before the labels feed a decision. Keep arithmetic out of =COPILOT() and in ordinary formulas. Generated text is a poor home for a total or percentage that you need to recalculate and reconcile.
Verify every formula with the same routine. State what the result means, inspect each reference, and check the blank, zero, and error logic. Fill only the intended rows. Then use inputs whose answers are already known. Revenue 1200 and cost 720 must produce 40%. Revenue 850 and cost 900 must produce about -5.88%. Revenue 0 must display a blank. A result from a known input tells you more than a formula that merely looks plausible.
Excel may also suggest a formula while you type. On Windows, the switch is under File > Options > Copilot, labeled "Automatically generate formula suggestions." Treat the suggestion as a shortcut. Accept it only when it matches the formula you would write and uses the intended rows and operation. The setting controls whether suggestions appear. It doesn't check them for you.
Generation and explanation are two jobs
Generating a formula and explaining one are different tasks, and keeping them separate is a safeguard. Ask Copilot to generate when you know the business rule but need the syntax. Ask it to explain when you've inherited a workbook and want to know what a cell does: "Explain the formula in the selected cell in plain language, list the columns and ranges it uses, describe how it handles blanks and zeros, and give me two test cases. Do not change the workbook."
An explanation is a claim too. Compare Copilot's description against the formula bar. If it calls a division by cost "margin," the description and the formula disagree, and one of them is wrong. Then confirm with a live test: change an input to a value whose result you know and watch the cell update. If the workbook matters, keep the prompt, the accepted formula, and any correction together, so the next person can see what the formula is and why you trusted it.
Delegate multi-step edits, with guardrails
Sometimes the task includes more than one formula. You may want Copilot to format columns, add a calculated column, highlight rows, and sort the table in one request. Edit with Copilot is Excel's agentic editing experience. Microsoft previously called it Agent Mode, and the agentic capabilities across Word, Excel, and PowerPoint became generally available on April 22, 2026. It can carry out a sequence of workbook changes from one request, so the boundary needs to be explicit.
Bound each edit with a goal, context, source, and expectations, and define any business term rather than letting Copilot infer it. "Margin," "at risk," and "late" mean different things in different organizations, so give the exact formula, threshold, or status text. Before editing, write down two or three invariants, such as the row count, a key total, the Order IDs, or the requirement that existing formulas survive, and always work on a copy. Then treat "plan, execute, inspect, approve" as your own workflow, not a guaranteed product mode: inspect the workbook itself afterward, because a fluent completion report can describe changes that didn't happen or miss changes that did. Verify the totals and formulas, not the narrative.
