When working with Excel, you can ENCOUNTER the following six types of errors:

#N/A ERROR: This is called the ‘Value Not Available’ error. You will see this when you use a lookup formula and it can’t FIND the value (hence Not Available).

#DIV/0! Error: You’re likely to see this error when a number is divided by 0. This is called the division error.

#VALUE! Error: The value error occurs when you use an incorrect data type in a formula.

#REF! Error: This is called the reference error and you will see this when the reference in the formula is no longer valid. This could be the case when the formula refers to a cell reference and that cell reference does not exist (happens when you delete a row/column or worksheet that was referred in the formula).

#NAME ERROR: This error is likely to a result of a misspelled function.

#NUM ERROR: Number error can OCCUR if you try and calculate a very large value in Excel. For EXAMPLE, =194^643 will return a number error.

When working with Excel, you can encounter the following six types of errors:

#N/A Error: This is called the ‘Value Not Available’ error. You will see this when you use a lookup formula and it can’t find the value (hence Not Available).

#DIV/0! Error: You’re likely to see this error when a number is divided by 0. This is called the division error.

#VALUE! Error: The value error occurs when you use an incorrect data type in a formula.

#REF! Error: This is called the reference error and you will see this when the reference in the formula is no longer valid. This could be the case when the formula refers to a cell reference and that cell reference does not exist (happens when you delete a row/column or worksheet that was referred in the formula).

#NAME ERROR: This error is likely to a result of a misspelled function.

#NUM ERROR: Number error can occur if you try and calculate a very large value in Excel. For example, =194^643 will return a number error.