Will it edit my formula?

It suggests a corrected version of your formula along with a short explanation of the fix.

Formula Error Helper

Diagnose #REF!, #VALUE!, #DIV/0! and other formula errors fast.

Paste a formula or error message

Or pick an error

About Formula Error Helper

Formula Error Helper explains why your Excel formula is throwing an error and how to fix it. Paste the formula and the error message to get targeted suggestions.

Frequently asked questions

All standard Excel errors: #REF!, #VALUE!, #DIV/0!, #NAME?, #NUM!, #N/A, #NULL!, and #SPILL!.

More formula tools

Formula Explainer

Paste any Excel formula and get a clear, plain-English explanation.

Formula Generator

Describe what you need in plain English and get the matching Excel formula.

Excel Function Finder

Search Excel functions by name or by what you want to do.

Browse other categories

Spreadsheet Utilities Data Cleaning Tools

Back to Excel for Monkeys