Excel shows the #VALUE! error when your formula includes cells that have different data types (text and numeric values). The #VALUE! error is also shown when a formula references one or more cells that have text instead of numbers, and uses the standard math operators (+, -, *, and /) to add, subtract, multiply, or divide the different data types.| support.microsoft.com
The top reason why the #NAME? error appears in your formula is because there is a typo in the formula name. To avoid typos in formula names, use the Formula Wizard in Excel.| support.microsoft.com
Correct a #N/A error in Excel| support.microsoft.com
Use IF or IFERROR to correct a #DIV/0! error in Excel| support.microsoft.com
When checking formulas, use the Trace Precedents and Trace Dependents commands to display the relationships between these cells and formulas.| support.microsoft.com
Correct a #REF! error in Excel| support.microsoft.com
Formulas can sometimes result in error values in addition to returning unintended results. Learn about best practices to avoid those problems.| support.microsoft.com