Information functions
All 20 functions in this category
ISBLANKISBLANK returns TRUE if a cell is completely empty, FALSE if it contains any value or formula, and propagates errors.ISERRORISERROR returns TRUE if a value is an error like #N/A or #REF!, FALSE otherwise, enabling error detection and handling.ISERRISERR returns TRUE for spreadsheet errors (like #DIV/0! or #REF!) but not #N/A, helping you trap formula calculation failures.ISNAISNA detects whether a value is the #N/A error, typically returned when a lookup function fails to find a match.ISNUMBERChecks whether a value is a number, returning TRUE for numeric values and FALSE for text, dates, blanks, and errors.ISTEXTReturns TRUE if a value is text, FALSE otherwise. Use ISTEXT to validate data types or filter columns before performing calculations.ISNONTEXTISNONTEXT returns TRUE when a value is anything except text—numbers, booleans, dates, or errors—ideal for validating data types in spreadsheets.ISLOGICALISLOGICAL checks whether a cell contains a TRUE or FALSE value, returning TRUE only if the value is a logical value, useful for validating data types.ISREFISREF returns TRUE if a value is a cell reference, FALSE otherwise; use it to validate whether a result is a reference rather than a computed value.ISFORMULAReturns TRUE if a cell contains a formula, FALSE if it's a static value; use it to audit which cells drive calculations versus hard-coded data.ISEVENISEVEN returns TRUE if a number is even, FALSE if odd, making it useful for identifying parity in datasets for grouping or filtering.ISODDISODD returns TRUE if a number is odd, FALSE if even—use it to filter, validate, or categorize numeric data by parity for analysis and reporting.NAReturns the #N/A error value, used to explicitly mark cells or formulas with data that is unavailable or unknown.ERROR.TYPEERROR.TYPE returns a number 1–7 identifying the type of error, letting you handle different errors individually or display a helpful message to users.TYPEReturns a number indicating the data type of a value: 1 for numbers, 2 for text, 4 for logical values, 16 for errors, and 64 for arrays.CELLCELL returns information about a cell's location, contents, or formatting, such as its address, row, column, or data type.INFOINFO returns information about the current operating environment, application version, and available system resources.NN converts a value to a number, returning the numeric equivalent of dates, booleans, and numeric text strings.SHEETSHEET returns the index number of a sheet containing a reference, or the current sheet's number if no argument is given.SHEETSSHEETS returns the total number of sheets in the workbook, or the sheet number containing a specified cell reference.