AIFormula

Formula and error explainer

AI formula and error explainer for Australian and New Zealand accounting professionals

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

  1. Step 1

    Upload the workbook

    Attach the CSV or XLSX containing the formula or error you're chasing.

  2. Step 2

    The trace runs

    Formulas are parsed and dependencies traced to find where the error originates.

  3. 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