Differences Between ISERR and ISNA Functions in Google Sheets

Published on

To correctly understand the differences between the ISERR and ISNA functions, learning how to use them individually is essential.

ISERR—not to be confused with ISERROR—and ISNA are both simple and easy-to-use functions. But why are we comparing ISERR with ISNA, and why is it relevant?

The reason is that both functions deal with errors in Google Sheets, specifically the #N/A error. Let’s dive into the details.

How to Use the ISERR Function in Google Sheets

Purpose:

The ISERR function checks if a value results in any error other than #N/A.

Syntax:

ISERR(value)

Examples:

To better understand the ISERR function, let’s explore some common error types in Google Sheets.

Google Sheets ISERR Formula Examples

In the range C1:C10, you can see various error types that Google Sheets may return based on different formulas used in those cells.

While I’ll explain the formulas behind these errors in another tutorial, let’s focus on how to use the ISERR function.

In cell E1, I’ve applied the following formula, which has been copied down to the rest of the cells:

=ISERR(C1)

Note that the formula returns FALSE in cells E2, E3, and E10. Do you know why this happens?

The ISERR function considers all error types except #N/A as errors. Since the values in C2 and C10 are not errors, the ISERR formulas in E2 and E10 return FALSE.

Interestingly, ISERR does not treat #N/A as an error, so the formula in E3 also returns FALSE.

How to Use the ISNA Function in Google Sheets

Now that you understand ISERR, let’s move on to ISNA and explore the differences between these two functions.

Purpose:

The ISNA function specifically checks whether a value results in the #N/A error.

Syntax:

ISNA(value)

Examples:

In cell F1, I’ve applied the following formula, which is then copied down the column:

=ISNA(C1)

Now, take a look at cell F3 in the screenshot below. The formula returns TRUE, indicating the presence of a #N/A error in C3:

How to Use ISNA Function in Google Sheets
=ISNA(C3)

Since C3 contains the #N/A error, the ISNA function correctly returns TRUE in F3.

Differences Between ISERR and ISNA Functions

It’s important to compare ISERR with ISNA to understand how they differ. Take a look at the results in columns E (for ISERR) and F (for ISNA).

Take note of the highlighted cells in these columns. The ISERR function treats #N/A as non-error, returning FALSE. It also returns FALSE for any non-error values like numbers or text.

On the other hand, the ISNA function is exclusively concerned with the #N/A error. It only returns TRUE if the value in a cell is #N/A.

I hope this tutorial has helped you understand the usage and differences between the ISERR and ISNA functions in Google Sheets. Thank you for reading, and I hope you found this guide helpful!

Prashanth KV
Prashanth KV
Your Trusted Google Sheets and Excel Expert Prashanth KV is a Diamond Product Expert in Google Sheets, officially recognized by Google for his contributions to the Docs Editors Help Community and featured in the Google Product Experts Directory. Explore his blog to learn advanced formulas, automation tips, and problem-solving techniques to elevate your spreadsheet skills.

Calculate Trip Days by Month (Start, End, and Full Days) in Google Sheets

If you're managing business travel in Google Sheets, you may need to calculate how...

Mode of Comma-Separated Numbers in Excel (Dynamic Array)

There is no dedicated function in Excel to directly find the mode of comma-separated...

How to Find Mode of Comma-Separated Numbers in Google Sheets

Working with comma-separated numbers inside a single cell is a common scenario in Google...

How to Count Merged Cells in Google Sheets (and Get Their Size)

Sometimes, you may have blocks of merged cells in a column or row. But...

More like this

Calculate Trip Days by Month (Start, End, and Full Days) in Google Sheets

If you're managing business travel in Google Sheets, you may need to calculate how...

How to Find Mode of Comma-Separated Numbers in Google Sheets

Working with comma-separated numbers inside a single cell is a common scenario in Google...

How to Count Merged Cells in Google Sheets (and Get Their Size)

Sometimes, you may have blocks of merged cells in a column or row. But...

LEAVE A REPLY

Please enter your comment!
Please enter your name here

This site uses Akismet to reduce spam. Learn how your comment data is processed.