Information functions

Functions in EnglishFunctions in FrenchDescription of Function
CELLCELLULEReturns information about the formatting, location, or contents of a cell.
ERROR.TYPETYPE.ERREURReturns a number corresponding to an error type.
INFOINFORMATIONSReturns information about the current operating environment.
ISBLANKESTVIDEReturns TRUE if the value is blank.
ISERRESTERRReturns TRUE if the value is any error value except #N/A.
ISERRORESTERREURReturns TRUE if the value is any error value.
ISEVENEST.PAIRReturns TRUE if the number is even.
ISFORMULAESTFORMULEReturns TRUE if there is a reference to a cell that contains a formula (2013).
ISLOGICALESTLOGIQUEReturns TRUE if the value is a logical value.
ISNAESTNAReturns TRUE if the value is the #N/A error value.
ISNONTEXTESTNONTEXTEReturns TRUE if the value is not text.
ISNUMBERESTNUMReturns TRUE if the value is a number.
ISODDEST.IMPAIRReturns TRUE if the number is odd.
ISREFESTREFReturns TRUE if the value is a reference.
ISTEXTESTTEXTEReturns TRUE if the value is text.
NNReturns a value converted to a number.
NANAReturns the error value #N/A.
SHEETFEUILLEReturns the sheet number of the referenced sheet (2013).
SHEETSFEUILLESReturns the number of sheets in a reference (2013).
TYPETYPEReturns a number indicating the data type of a value.