Common Excel Errors and How to Resolve Them

While working with functions or processing data in Excel, encountering errors is inevitable. Knowing the causes and solutions will help you address issues quickly when they arise.

This article presents some common errors in Excel and ways to fix them.

1. ##### Width Error.

Error occurs when the column lacks width, and you input date or time values as negative numbers.

Adjust the width for the column to rectify this issue.

2. #VALUE! Value Error.

Value errors are common when using functions such as:

- Entering or editing a function without completing it before pressing Enter.

- Inputting an argument for a function as a string when the function requires a number or a logical value.

- Inputting too many parameters for an operator or a function when it only requires a single parameter.

- Having operations with different data types within a function.

Ensure accurate input of functions and their parameters; operations should involve matching data types.

3. #NAME! Incorrect Name.

Various reasons lead to name errors:

- Using unauthorized characters within the formula.

- Entering the wrong function name may result from typing quickly or using the Vietnamese input method.

- Using functions that are not commonly used in Excel, such as EDATE, WORKDAYS…

- Not using double quotation marks ' when entering strings into functions.

- In the range of cell addresses in the formula, lacking the necessary colons :.

To address this error, review the function name, structure, and syntax. To enable standard functions, go to Tools -> Add-in, and mark the Analysis ToolPak utility.

4. #DIV/0! Division by 0 Error.

When this error occurs, it indicates that your formula has a divisor of 0 or the divisor in the formula refers to an empty cell. Check the divisor in your formula and make necessary adjustments.

Review the divisor in your formula and make suitable changes to resolve this issue.

5. #REF! Incorrect Reference Range.

Error in the reference range occurs when:

- Linking or referencing to an application that cannot run.

- Referenced cell is deleted or does not exist.

To resolve the incorrect reference range error, you should review and edit the referenced cells.

6. #N/A Data Error.

Causes of the error:

- Using HLOOKUP, VLOOKUP, MATCH functions to retrieve a value in an unsorted table.

- The returned value is not compatible.

- Inconsistency in data when using array addresses in Excel.

- Using an inappropriate custom function.

- Forgetting parameters in custom functions.

Carefully review the formula and adjust the cell referenced by the function, organize data for the reference table when using lookup functions...

7. #NULL! Empty data error.

Empty data error occurs when:

- Using an array without proper separation.

- Using an inappropriate range of operators.

To address the empty data error, review and correct issues arising from the above reasons.

8. #NUM! Numeric data type error.

Cause:

Using a function that returns a number too large or too small for Excel's computational capabilities.

Repeatedly using a looping function leading to the function not finding a return result.

Using an inappropriate argument in a formula where the argument should be numerical data.

Ensure correct input of arguments in the formula, adjust and scale the calculation values to align with Excel's computational capabilities.

Here are some common errors encountered in Excel. If you come across these issues, you can implement the most effective troubleshooting measures. Wishing you success!