• 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