IsError

The function wizard for the IsError function:

Syntax

IsError(Value)

Parameters

Value. Checked value.

Description

It checks if the value is error.

Comments

It returns TRUE if the value refers is error, otherwise it returns FALSE.

Numbers, empty cells, logical values, text, cell references, and formulas can be used as a parameter value.

Example

Formula Result Description
=IsError(C2:E9) FALSE The range of cells C2:E9 does not contain errors.

See also:

Function Wizard │ Logical Functions