How to use the Spreadsheet Formula Explainer.
Explain a formula using the meaning of its cells and ranges. Syntax alone may not reveal whether the calculation fits the business question.
Make the workflow fit your task.
Provide the formula, cell meanings and representative values. Explain each nested operation from the inside out, then connect the final result to the question the sheet is answering. Include what happens for missing or unexpected inputs.
- What you provide
- Formula and column meanings.
- What you get
- Plain-language account of calculation and edge cases.
See the input and the result.
Illustrative input and output · a teaching example, not a live WebAct run
Example input
=SUMIF(A2:A10,"Paid",B2:B10)
Completed example
Adds amounts in B2:B10 for rows whose status in A2:A10 is Paid; other rows are excluded.
Load this input into the prompt, then copy it to WebAct to try the task. Your result may differ from the illustration.
Decisions and troubleshooting.
Should an explanation include the dollar signs in cell references?
Yes. Explain which row or column stays fixed when the formula is copied, since that can change its meaning elsewhere.
Why does the explanation disagree with the displayed result?
Check calculation settings, hidden precision, text values and the actual referenced cells. The formula alone may not reveal these workbook conditions.
Try it with your own source.
Replace the example with your material in the task prompt. Keep the requirements you need, then copy the task into WebAct.
Customize and copy the task ↑