Common Errors Occur In Excel Operations

In the process of manipulating Excel worksheet, you often encounter error characters, you wonder where the wrong cause is and how to handle it?

Error manifestations, Causes, and workarounds in Excel

#####

Error width

The character in the cell is longer than the width of the column =>Use the mouse to drag thecolumn wide tomatch

When you enter the date or time value as a negative number.

#VALUE!

Error value

You enter a string formula while the function requires a number or a logical value.

Entering one or editing elements of a formula that press Enter.

Enter too many parameters for an operator or a function while they only use one parameter.Example = LEFT (A2: A5)

Executes a marco (automated command )relatedto afunctionthat returns the #VALUE! Error.

Appears when in formulas there are calculations that are not of the same data type.For example, the formula = A1 + A2,where A1 is a number, A2 is a letter, because 1 is an arithmetic character, and Tây Ninh is a character string so it cannot perform calculations.To fix, you must edit for the values of the operations that have the same data type as arithmetic characters or string literals.

Common Errors Occur In Excel Operations Picture 1

# DIV / 0!

Error divided by 0

Enter the divisor formula as 0. For example = A1 / B1 where B1 = 0.

The divisor in the formula is a reference to a blank cell.

#NAME!

Wrong name

You use non-permanent functions in Excel such as EDATE, EOMONTH, NETWORKDAYS, WORKDAYS, . Then you need to go tothe Tools - Add-in menu.Tick the Analysis ToolPak utility.

Enter the wrong name for a function.This case happens when you use Vietnamese keyboard in Telex mode to accidentally make the function name as IF become ER, VLOOKUP to VLÔKUP.

Use illegal characters in formulas.

Enter a string in the formula without closingand opening quotation marks. ""

No colon: inthe range of cell addresses in the formula.

(Excel does not recognize the nameof the formula. For example, the function = SM (BBB), in this function, both the formula name and the array name are incorrect. To fix it, you must correct the function nameor enter it correct array to reference.)

# N / A

Data error

Incompatible return values from [color =] [/ color] lookup functions like VLOOKUP, HLOOKUP, LOOKUP or MATCH.

Use HLOOKUP, VLOOKUP, MATCH to return a value in an unsorted table.

Inconsistent data when you use array addresses in Excel.

Forget one or more arguments in the generated function.

Using an improperly created function

(Occurs when the formula refers to a cell in an array, but the cell has no value. This error often occurs with search functions such as VLOOKUP, HLOOKUP, etc. Fix the cell that the function refers to.)

#REF!

Wrong reference region

Delete the cells that are referenced by the formula.Or paste the values generated from the formula into the formulareference regionitself.

(This is a cell reference error, for example, if you delete a row or column that is used in a formula, the #REF! Error will be displayed.)

Link or reference to an application that cannot be run.

#NUM!

Number data error

Using an inappropriate argument in a formula that uses argument as anumeric dataFor example, youenter a negative number formula while it only calculates positive numbers.

Repeated use of the function results in a function that returns no results.

Use a function that returns a number that is too big or too small for Excel's calculation capabilities .

(The numeric value in the formula is invalid, the number is too large or too small. For example, the calculation = 99 ^ 999 will get the #NUM! Error, you just need to reduce the recalculated value.)

#NULL!

Empty data error

Using an inappropriate sequence of operators

Use an array without separators.

(This error occurs when using operators like = SUM (A1: A5 B1: B5), there is no intersection between these two functions , to fix you must determine the exact intersection point between the two functions. .)