Information

  • CELL information of type about cell
  • COUNTBLANK the number of blank cells in range
  • ERROR the error with the given name
  • ERROR.TYPE the type of error
  • EXPRESSION expression in cell as a string
  • GET.FORMULA the formula in cell as a string
  • GET.LINK the target of the hyperlink attached to cell as a string
  • GETENV the value of execution environment variable name
  • INFO information about the current operating environment according to type
  • ISBLANK TRUE if value is blank
  • ISERR TRUE if value is any error value except #N/A
  • ISERROR TRUE if value is any error value
  • ISEVEN TRUE if n is even
  • ISFORMULA TRUE if cell contains a formula
  • ISLOGICAL TRUE if value is a logical value
  • ISNA TRUE if value is the #N/A error value
  • ISNONTEXT TRUE if value is not text
  • ISNUMBER TRUE if value is a number
  • ISODD TRUE if n is odd
  • ISREF TRUE if value is a reference
  • ISTEXT TRUE if value is text
  • N text converted to a number
  • NA the error value #N/A
  • TYPE a number indicating the data type of value