Our Recommendation for You Search your Query, You can find easily. for example search by book name or course name or any other which is related to your education

Followers

Error Messages List in Excel

When working in Excel and creating formulas, Excel can return the result as an error. Errors in Excel described in this tutorial shows the following:

Error Message ###### in Excel 2013

If the cell you see an error message in the form of the string scale (sharp/hash) then you notice that Excel cannot display the data or the result of a formula, and also perhaps the result of a negative date. This error message in Excel sometimes referred to as the 'Railroad tracks'. To eliminate this error, increase the width of a column or a cell or if it is a result of a formula then make arguments formula. e.g. = ISERROR(50/0) formula will return TRUE and the result will not be the fault.

Error Message ###### in Excel

ERROR message #DIV/0!

Error message #DIV/0! occurs when the set of formulas in which a number is divided by zero (0). To avoid this error, check the formula in the cell where the error occurs and possibly change the divisor.

How to avoid error message #DIV/0! in Excel

ERROR message #N/A

Error #N/A! occurs when a value that you include in the formula is not available. To avoid this error, check the desired value in the range of cells. This error can be avoided by using an additional Excel function IFERROR (see links at the end of this tutorial) =IFERROR(VLOOKUP(A6;$A$1:$B$4;2;FALSE);"").

How to avoid error message #N/A in Excel

ERROR message #NAME?

Error #NAME? occurs when the set of formulas that Excel can not calculate because of no defined name or the name of the particular information. In this case the image below notice that I did not set separator colons (:) in the formula. Elimination of these errors can be solved by adjusting the formula or function using IFERROR or ISERROR.
  • the formula has used a name that is not defined, or the existing name is misspelled
  • wrong is a function name
  • names are used in formulas, without this option enabled
  • the formula is entered text without being placed in double quotes
  • omitted the colon in a reference range of cells
  • referenced is the other name of the worksheet without having his name placed in single quotes
How to avoid error message #NAME! in Excel

ERROR message #NULL!

Error #NULL! appears when you specify an intersection of two areas that do not intersect. The intersection operator is a space between the reference. In this case the image below notice that the operator used an incorrect range (for reference consisting of a continuous group of cells using the colon (:) as an operator (for example A1:B2) and to reference ranges that are continuously used semicolon (;) operator (e.g. A1, A3). So semicolon (;) is a separator or divider for two ranges of cells in this formula. Eliminating these errors can be solved by adjusting the formula or using ISERROR or IFERROR functions.

How to avoid error messages #NULL! in Excel

ERROR message #NUM!

Error #NUM! appears when you are not listed numbers or values that are important to the formula. Also this error occurs when Excel can not calculate an operation with the values or numbers. To remove these errors, see the formula, and if you write all the arguments function properly. In the picture below you notice that Excel returns a #NUM! because the result is too big and excel in it can not be displayed. Elimination of these errors can be solved by adjusting the formula or function using IFERROR or ISERROR.

How to avoid error message #NUM! in Excel

ERROR message #REF!

Error #REF! occurs when a missing cell in which the formula references. The frequent occurrence of this error is when we delete a cell from a formula that pulls data or if we delete the worksheet that contains the data that uses formulas or functions. Elimination of these errors can be solved by adjusting the formula or function using IFERROR or ISERROR.

How to avoid error message # REF! in Excel

ERROR message #VALUE!

Error #VALUE! occurs when using a defective argument type of function or formula.
  • used the wrong type of argument a function (for example, instead of values or logical values used text
  • array formula was entered without the key combination Ctrl+Alt+ Enter
  • reference is entered as a formula field (e.g. {A10:A48})
  • in place of the argument that requires a value added is a range of cells
Elimination of these errors can be solved by adjusting the formula or function using IFERROR or ISERROR.

Notice in the picture below that the first formula pulls data from cell A6 which lists the text in the second formula the second argument is not properly written.

How to avoid error message #VALUE! in Excel

For all the errors messages (except first) that are described in this tutorial is worth further text. If you do not want to change the formula, eliminating display error message, you can do so by using ISERROR or IFERROR functions.