In this Article

This tutorial demonstrates how to use the **Excel ISERR Function** in Excel to test if a cell results in an error (excluding #N/A).

## ISERR Function Overview

The ISERR Function Test if cell value is an error. Ignores #N/A. Returns TRUE or FALSE.

To use the ISERR Excel Worksheet Function, select a cell and type:

(Notice how the formula inputs appear)

### ISERR Function Syntax and Inputs:

=ISERR(VALUE)

**value** – The test value

## How to use the ISERR Function

The ISERR Function checks if a calculation results in any error, except the #N/A error.

=ISERR(A2)

### ISERROR, ISERR, and ISNA

There are two other error checking “is” functions:

- The ISNA Function returns TRUE only for #N/A errors.
- The ISERROR Function returns TRUE for all errors.

There are also the IFERROR and IFNA Functions that test for errors, allowing you to do something if an error is found.

=IFERROR(VLOOKUP(A2,$E$2:$F$7,2,FALSE),"No Data") =IFNA(VLOOKUP(A2,$E$2:$F$7,2,FALSE),"No Data")

### Other Logical Functions

Excel / Google Sheets contain many other logical functions to perform other logical tests. Here is a list:

IF / IS Functions |
---|

iferror |

iserror |

isna |

iserr |

isblank |

isnumber |

istext |

isnontext |

isformula |

islogical |

isref |

iseven |

isodd |

## ISERR in Google Sheets

The ISERR Function works exactly the same in Google Sheets as in Excel:

## ISERR Examples in VBA

You can also use the ISERR function in VBA. Type:

`application.worksheetfunction.iserr(value)`

For the function arguments (value, etc.), you can either enter them directly into the function, or define variables to use instead.

Return to the List of all Functions in Excel