TLE Computer ERROR TYPE

Subdecks (3)

Cards (46)

  •  #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
  • directory - Path of the current directory
  • numfile - The number of active worksheets in all currently open Excel Workbooks
  • origin - Returns the top left cell reference of the current worksheet (generally A1) and the top left cell that is currently visible in the scrolled area of the current worksheet.
  • osversion - Current operating system version
  • recalc - Current recalculation mode (either "Automatic" or "Manual")
  • release - Current version of Microsoft Excel
  • system - Current operating environment ("mac" = Macintosh or "pcdos" = Windows)
  • Syntax of error type is =ERROR.TYPE(error_val)
  • system - Current operating environment ("mac" = Macintosh or "pcdos" = Windows)