How to Use the ISNA Function in Google Sheets


When you get #N/A errors in google sheets, they may wreck your calculations as they break many of the formulas if you utilize them in any kind of calculation. But the problems associated to them can be solved by using ISNA function.

ISNA function is the one that examines the value to see if it’s a #N/A mistake. If the error is #N/A the function returns True; otherwise it returns False.

The syntax for this function is –

=ISNA(value)

  • Value – this is the value or cell reference that you want to check for an #N/A error.

To make you understand better, here is an example of its usage.

ISNA example-1

Here, we have a lookup function in column B and some of the cells exhibit #N/A errors. In column see it can be seen that ISNA function returns True for cells with errors and False for everything else.

Because this method just takes one input, it’s quite easy to use. However, the ISNA function is mostly used in conjunction with another functions. To have an example here we’ll nest ISNA with IF function.

Using IF and ISNA Together

By nesting these functions together, we’ll be able to return a specific value if our ISNA function returns True and a different value if it returns False.

The syntax for this merger will be –

=IF(ISNA(value)), value_if_true, value_if_false)

IF ISNA example-1

The above example through an image displays the formula for this merged function and also shows the result of how a specific value is returned if these functions nests together.

Thus, it’s going to be a very promising and useful feature to work with on Google Sheets.

And creating a combination of this function with others eventually may lead you to find some more amazing results.

Harshita Mathur

My name is Harshita Mathur. I come from Jaipur, Rajasthan. I am a law student. Apart from this I am an amateur writer.

Recent Content