Fix formula errors
What #DIV/0!, #NAME?, #VALUE!, #REF!, #N/A and #SPILL! mean and how to fix them.
Point at a cell with an error to see an explanation.
| Error | Meaning | Fix |
|---|---|---|
#DIV/0! |
Division by zero or an empty cell | Check the divisor, or use IFERROR |
#NAME? |
Unknown function or name | Check the spelling |
#VALUE! |
Wrong type of value, such as text in a sum | Check the cells used |
#REF! |
A cell the formula used was deleted | Fix the reference |
#N/A |
A lookup found nothing | Check the value looked up |
#SPILL! |
Results can't spill because cells are in the way | Clear the cells below or beside |
#NUM! |
Invalid number | Check the arguments |
A circular reference — a formula that depends on itself — is reported too.
Was this article helpful?
Related articles
Still need help?
Write to the Woosool team. Sign in with your Woosool Account and we reply by e-mail and in My requests.