Formulas > =ISERROR()

How to Use ISERROR() in Google Sheets

Description

Checks whether a value is an error.

How To Actually Use ISERROR() in Sheets

ISERROR(value)

Try ISERROR yourself

In the range B1:B10, use the ISERROR formula to check if each cell contains an error. Your formula should return TRUE for errors and FALSE for non-errors.

Your formula

Hints (2)

Locale Separator ,

Official Docs

Looking for a video tutorial? Members can email me anytime! Check out the blogs below for more info on this formula. Or generate your formula. Find more formulas here at BetterSheets.co/formulas

Transcript-matched member videos for ISERROR(). Click through to watch.

Watch more tutorials

Most Common Errors and How To Handle Them in Google Sheets

Today we're gonna talk about errors in Google Sheets and how you can fix...

Beginner

CONCATENATE() VLOOKUP()

Unlock these tutorials

Learn more about the ISERROR() formula:

Generate a ISERROR() formula for your needs

Describe your task in plain English and get a paste-ready formula that uses ISERROR(). 2 free AI generations, no signup. Members get unlimited use.

Generate a ISERROR() formula

How to Use ISERROR() in Google Sheets

Try ISERROR yourself

More related tutorials

Most Common Errors and How To Handle Them in Google Sheets