ISERROR function in Excel

Syntax

=ISERROR(value)

Example

=IF(ISBLANK(A2),"Missing",A2) shows "Missing" for empty cells.

From the lesson IS Functions.

Common mistakes

• A cell with a space looks blank but ISBLANK says FALSE.
• Numbers typed as text (like "42") make ISNUMBER FALSE.

Related logical functions

• IFReturns one value if a test is TRUE and another if FALSE.
• IFSChecks conditions in order and returns the first TRUE match.
• IFERRORReturns a fallback when a formula errors.
• IFNAReturns a fallback only for #N/A errors.
• SWITCHMatches an expression against a list of values.
• ANDTRUE if all arguments are TRUE.
• ORTRUE if any argument is TRUE.
• XORTRUE if an odd number of arguments are TRUE.