• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Information Functions

Information Functions

CELL(info_type,reference)Returns information about the formatting, location, or contents of a cell.
ERROR.TYPE(error_val)Returns a number corresponding to an error value.
INFO(type_text)Returns information about the current operating environment.
ISBLANK(value)Returns TRUE if the value is blank.
ISERR(value)Returns TRUE if the value is any error value except #N/A.
ISERROR(value)Returns TRUE if the value is any error value.
ISLOGICAL(value)Returns TRUE if the value is a logical value.
ISNA(value) Returns TRUE if the value is the #N/A error value.
ISNONTEXT(value)Returns TRUE if the value is not text.
ISNUMBER(value)Returns TRUE if the value is a number.
ISREF(value)Returns TRUE if the value is a reference.
ISTECT(value)Returns TRUE if the value is text.
N(value)Returns a value converted to a number.
NA( )Returns the error value #N/A.
TYPE(value)Returns a number indicating the data type of a value.



PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint