Fix broken Excel formulas with the error in context.
Paste the formula, the error, and what should happen. Get a correction you can test.
How to fix a formula
01
Paste the broken formula
Include the leading equals sign and every parenthesis from the formula bar.
02
Enter the error
Use the exact token: #N/A, #VALUE!, #NAME?, #REF!, #SPILL!, or #DIV/0!.
03
Describe the expected result
Give one sample row and the value that cell should show.
04
Test the correction
Paste the new formula on a copy of the row before you replace the original.
Fix the error, not a guess
Most broken formulas fail for a specific reason: no lookup match, text in a math cell, a blocked spill range, or a zero denominator. Tell the fixer those facts. If you only need to understand a working formula, use the explainer instead.
Common Excel errors
- Error labClick a broken sheet, then send #REF!, #SPILL!, or #CALC! here.
- #N/ALookup miss. Check types, spaces, and exact match.
- #VALUE!Wrong argument type. TRIM, VALUE, or DATEVALUE the inputs.
- #SPILL!Dynamic array is blocked. Clear the output range.
- #DIV/0!Denominator is zero or blank. Guard before dividing.
Formula fixer FAQ
What should I paste into the fixer?
The current formula, the exact error (#N/A, #VALUE!, #SPILL!, #DIV/0!, or a wrong number), and one example of the result you expected.
Is this the same as the generator?
No. The generator writes a new formula from a description. The fixer starts from a formula that already failed.
Where can I read about each error?
The Excel errors guides cover #N/A, #VALUE!, #REF!, #SPILL!, and #DIV/0!. The error lab also includes #CALC! and can send a sample into this fixer.