By Giang Doan

- How to fix errors in Excel quickly
- Excel - Process mistakes related to date in Excel
- Excel - How to using the SUM function
- Excel – FREQUENCY function, counting frequently-appeared values

When using Excel spreadsheets, surely no one can avoid mistakes. So how to fix it? The following article will give you some common mistakes in Excel and their solutions.

__Excel - common errors and their solutions__*1. The width error: # # # # #*

**- Causes:**

+ When data cell lacks of widths.

+ When you enter a negative value for date or time.**- Solution:** Edit the column widths reasonably.*2. Value error: # VALUE!***- Causes:**

+ Press Enter while a formula is being edited.

+ Enter the formula to calculate a sequence while the function requires a number or a logical value.

+ Enter too many parameters to a function or formula while only one parameter is needed.

+ Execute a command related to a function where the function offer wrong value.*3. Data Null Error: # NULL!***- Causes:**

+ Use a inappropriate sequence.

+ Using an array with no separation.*4. Number-styled data Error: # NUM!***- Causes:**

+ Use repetitive functions which make the function cannot get the return value.

+ Use a function that returns too large or too small value compared to the calculation ability of Excel. (In this case, you can reduce the value)

+ Use an inappropriate argument in the formula.*5. Wrong Reference: # REF!*

**- Causes:**

+ The reference of the formula is deleted.

+ Links, reference to an application is not executable.*6. Data Error: # N / A***- Causes:**

+ The return value is not compatible with the detection functions.

+ Forger one or more arguments in the custom function.

+ Use an unreasonable custom function (In this case, you should carefully check and edit the cell referred by the formula)

+ Inconsistent data when you use the address array in Excel.*7. Divide by 0 Error: # DIV / 0*

**- Causes:**

+ Enter the formula with the divisor as 0.

+ Divisor in the formula refer to an empty cell.*8. Wrong Name: # NAME?***- Causes:**

+ Enter wrong name of function. For example, ì instead of if.

+ Use the symbols that are not allowed in the formula.

+ Use inconstant function in Excel (In this case, go to menu Tools → Add-ins. Tick Analysis ToolPak)

+ Add a string without putting it in double quotes.

+ Do not put “:” mark in reference.

Betdownload.com has synthesized errors and their causes occurring usually in Excel. Thus, you can understand more clearly the cause of the error and have effective measures for these errors.

- Related Articles:
- Excel - How to use the ConcateNate function to connect character strings in Excel
- Excel – How to create charts, graphs in Excel
- Excel – AVERAGEIF function, calculating average with conditions
- Excel – Auto-number columns
- Excel - Insert washout text and logo in Excel 2013
- Excel – Break a line in Excel

Related software

Excel Power Expander is a collection of useful and reliable utilities which are designed to extend the functionality of MS Excel. It provides 125 formulas and 87 new utilities.

- Word and Excel password Recovery wizard - Recover Word, Excel passwords
- Barcode Add in for Word and Excel - Tool to create barcodes in Word and Excel
- Belarc Advisor - Check and fix system errors

Excel – Examples and guidance for VALUE function- a function for converting string to number

To convert a string to a number, Excel supports you a function - VALUE function. Normally, you do not need to use Value function since Excel will

Excel – AVEDEV function, calculating absolute deviation average

In the analysis and data processing, you have to calculate the absolute deviation average of given variables. AVEDEV function will help you solve

AVERAGEIFS function, calculating average with multiple conditions

You have to calculate average score of subjects or numbers with given conditions. The consideration of conditions will be time-consuming without

Excel – AVERAGEIF function, calculating average with conditions

AVERAGEIF is used for calculating average of cells with given conditions. The function for calculating average with conditions is more sufficient and

Excel - PRODUCT function for multiplying

To multiply numbers, Excel supports you with a very convenient function-PRODUCT. This function helps you multiply numbers quickly and