Formula and error explainer
AI formula and error explainer for Canadian CPAs
Point at a confusing formula or a #REF!, #VALUE!, or #DIV/0! error and get a plain-English explanation, a dependency trace, and a safer replacement formula.
Try it freeInputs: 1 CSV or XLSX
How it works
- Step 1
Upload the workbook
Attach the CSV or XLSX containing the formula or error you're chasing.
- Step 2
The trace runs
Formulas are parsed and dependencies traced to find where the error originates.
- Step 3
Apply the fix
Read the explanation and paste in the suggested, safer formula.
What you get
- Formula explanation
- Dependency trace
- Suggested formula
Frequently asked questions
- Which errors does it explain?
- Common worksheet errors — #REF!, #VALUE!, #DIV/0!, #N/A and friends — plus formulas that compute without error but don't do what they look like they do.
- Is the output generated by an LLM?
- No. The workpaper numbers are computed by deterministic spreadsheet logic — the same inputs always produce the same outputs. AI is only used to route your request and explain the results, so every figure is traceable to source rows.
- What happens to my uploaded file?
- Files are processed to build your workpaper and stay attached to your private conversation. They are not used to train models.
Formula and error explainer is one question away
Open AIFormula, attach your file, and the formula and error explainer skill is pre-selected and ready to run.
Try it free