Formulas > =ISERR()
How to Use ISERR() in Google Sheets
Description
How To Actually Use ISERR() in Sheets
ISERR(value)
Try ISERR yourself
In cells B1:B10, use the ISERR formula to check if the corresponding values in A1:A10 are errors (excluding #N/A). The formula should return TRUE for errors and FALSE for non-errors.
Hints (2)
-
Remember to apply the formula to each cell in the range.
-
You can drag the formula down to fill the other cells.
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
Learn more about the ISERR() formula:
Generate a ISERR() formula for your needs
Describe your task in plain English and get a paste-ready formula that uses ISERR(). 2 free AI generations, no signup. Members get unlimited use.
Generate a ISERR() formula