ISERR

Checks whether a value is an error other than `#N/A`. Learn more

Video field
Info

In Google Sheets, ISERR is a function that checks whether the given value is an error or not.

It returns TRUE if the value is any error except #N/A, or FALSE if the value is not an error or is #N/A.

This function is useful in situations where you want to check whether a cell contains an error or not, and then perform certain actions based on that result.

Want even more from Google Sheets?


With Softr, you can turn your spreadsheets into powerful web apps.You can give advanced roles and permissions to each user, build advanced logic and automation flows, customize the design to your needs, and much more.


Softr also offers a growing library of templates for internal tools, client portals, community hubs, and more. The templates come with a Google Sheet or an Airtable base that you can use to store and manage your data easily.


Try Softr now and build your custom web apps in 10 minutes no code required!