Skip to main content

Information functions

NameDescriptionSyntax
ISLOGICALChecks if the value is logical. Returns TRUE if it is and FALSE if notISLOGICAL(value)
ISNAChecks if the value is the error #N/A (value not available). Returns TRUE if it is and FALSE if notISNA(value)
ISODDChecks if the value is an odd number. Returns TRUE if it is and FALSE if notISODD(value)
ISERRChecks if the value is an error other than #N/A (value not available). Returns TRUE if it is and FALSE if notISERR(value)
ISERRORChecks if the value is an error. Returns TRUE if it is and FALSE if notISERROR(value)
ISBLANKChecks if the cell is empty. Returns TRUE if it is and FALSE if it contains any data (including spaces, hidden characters and empty strings)ISBLANK(value)
ISREFChecks if the value is a cell reference. Returns TRUE if it is and FALSE if notISREF(value)
ISTEXTChecks if the value is text. Returns TRUE if it is and FALSE if notISTEXT(value)
ISEVENChecks if the value is an even number. Returns TRUE if it is and FALSE if notISEVEN(value)
ISNUMBERChecks if the value is a number. Returns TRUE if it is and FALSE if notISNUMBER(value)
NAReturns the error value #N/A (value not available)NA()
CELLReturns the information about the cellCELL(info_type, [reference])