Excel formula for some common error

 The following is the process of teaching experience several common error, and the cause of the error, is to summarize for reference only.

 # DIV / 0: appears in the formula is divided by 0 error.

 # N / A: In some of the data referenced in the formula is not available.

 # NAME?: the formula in the text, the system does not recognize.

 # NULL!: the designated intersection and did not happen.

 # NUM!: parameter input value is not correct.

 # REF!: cell reference is invalid.

 # VALUE!: supplied argument is not expected to use the system value type.