error.type

• Error.Type - returns a number that corresponds to a specific error value.
• ERROR.TYPE returns "#N/A" if no error was found
• Syntax of error.type:

  Syntax

  =ERROR.TYPE(error_val)
• Error Codes:

  #NULL! - 1

  #DIV/0 - 2

  #VALUE! - 3

  #REF! - 4

  #NAME? - 5

  #NUM! - 6

  #N/A - 7

  #GETTING_DATA - 8

  #SPILL! - 9

  #BLOCKED! - 11

  #CALC! - 14
• The Excel Info function - returns a text string containing information about the current operating environment.
• Syntax of the INFO function:

  =INFO( type_text )
• Identify

  A) Directory

  B) Numfile

  C) origin

  D) osversion

  E) recalc

  F) release

  G) system