Fix Formulas
Diagnoses and repairs broken Excel formulas and errors.
AI Prompt Generator
Craft an optimized prompt for any LLM in seconds.
PDF, Word, Excel, CSV, text, Markdown, JSON, XML, HTML & code — up to 5 files, 10 MB each. Files are analyzed and never stored or shared.
Great all-rounder for writing, code and analysis.
What this tool does
Diagnoses and repairs broken Excel formulas and errors.
When to use it
A formula returns #REF!, #VALUE!, or wrong results.
Prompt template
Act as an Excel troubleshooter. My formula [paste formula] returns [error/wrong result]. My data: [describe]. Explain why it fails and give the corrected formula.
Example
Fixing a VLOOKUP #N/A by switching to XLOOKUP with exact match.
Common mistakes to avoid
- Pasting the formula without context
- Not saying what the correct result should be
Best practices
- Paste the exact error
- Describe the expected output
Frequently asked questions
Do I need Microsoft Copilot to use this Excel tool?
No. You can generate the prompt here and paste it into ChatGPT, Claude, Gemini or Copilot. Copilot adds live access to your Excel file, which is convenient but optional.
Will the AI change my original file?
No. FormelyAI only generates text prompts. You copy the result and apply it yourself, so you stay in control of your documents.