This example illustrates the ISERROR function in Excel.

1. For example, Excel displays the #DIV/0! error when a formula tries to divide a number by 0.

Div/0! Error

The ISERROR function checks whether a value is an error and returns TRUE or FALSE.

2. Use the IF and the ISERROR function. If a cell contains an error, the value 5 is returned. If not, the value 100 is returned.

IsError Function in Excel


Did you find this information helpful? Please show your appreciation by sharing this page.

Go back to formula errors, Go to the right >>
Go to Top: IsError    |    Go to Next Example: Circular Reference