How to Use IsError function in Excel

Oct 31, 2020 • edited Nov 03, 2020

How to Use IsError function in Excel

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

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

ISERROR function in Excel

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


#Tutorial#How To#Functions#Formula Errors

How to Use Investment or Annuity In Excel

How to Use Left Lookup function In Excel