Error Functions
Functions for handling and managing errors in Excel formulas
CELL Function
The CELL function retrieves detailed information about any cell's formatting, position, contents, or properties. It's a powerful tool for dynamic formulas that adapt based on cell characteristics like data type, location, or applied formats.
Learn MoreIFERROR Function
The Excel IFERROR function returns a custom result when a formula generates an error, and a standard result when no error is detected. IFERROR is an elegant way to trap and manage errors without complex nested IF statements.
Learn MoreIFNA Function
The Excel IFNA function returns a custom result when a formula generates the #N/A error, and a standard result when no #N/A error is detected.
Learn MoreISBLANK Function
The ISBLANK function determines if a cell is truly empty, returning TRUE for empty cells and FALSE for cells containing any content including formulas, spaces, or zero-length strings. It's essential for accurate data validation and conditional logic in spreadsheets.
Learn MoreISFORMULA Function
The ISFORMULA function determines if a cell contains a formula rather than a static value. It returns TRUE for cells with formulas (including error-producing formulas) and FALSE for cells with direct values, text, or numbers.
Learn MoreISNUMBER Function
The ISNUMBER function determines if a given value is a number, returning TRUE for numeric values (including dates and times) and FALSE for text, errors, or logical values. Perfect for data validation and conditional formulas.
Learn MoreISOMITTED Function
The ISOMITTED function determines if a parameter passed to a LAMBDA function is missing or omitted. It returns TRUE when no value is provided for the argument, enabling flexible lambda functions that can handle variable numbers of parameters gracefully.
Learn More