LiveFlow raises $13.5 million Series A led by New York-based Valar Ventures and launches LiveFlow Next to revolutionize accounting!
Read More
Arrow
Back to guides
Google Sheets Formulas

ISNA Function in Google Sheets: Explained

In this article, you will learn about the ISNA function in Google Sheets and how to effectively use it for error handling.

What is the ISNA function in Google Sheets?

The ISNA function in Google Sheets is used to check whether a specific value or a formula result returns the #N/A error.

The #N/A error indicates that the value being looked up or referenced is not available or not found. The ISNA function returns TRUE or FALSE as the output.

The world's top businesses trust LiveFlow to automate their financial reporting
We turn Quickbooks Online data into a live FP&A dashboard in Sheets FAST!
Book a Demo

Uses of ISNA function in Google Sheets

The ISNA function in Google Sheets is primarily employed for error handling and data validation purposes. Some common applications include:

  • Checking for #N/A errors: Identify cells with #N/A errors and take appropriate actions, such as replacing the error with a value or modifying the formula to avoid the error.

  • Nested formulas: Combine ISNA with other functions like IF and IFERROR to create more complex formulas. For instance, test whether a VLOOKUP or INDEX formula returns an #N/A error and return a specific value or message if it does.

  • Data validation: Use ISNA in data validation rules to ensure users enter valid data. Set up rules that require users to input values not equal to #N/A in specific cells or ranges.

How to use the ISNA formula in Google Sheets

The formula is as follows:

=ISNA(value)

Where value is the cell or range of cells you want to check.

  • Select the cell where you want to display the outcome.

  • Enter the following formula into the cell: =ISNA(

  • Enter the value after the open parenthesis and then close the parenthesis.

Your next financial spreadsheet could be right here!
100+ spreadsheet templates, from FP&A to tax planning.
Free Spreadsheet Templates

Sample use case for ISNA function in Google Sheets

Suppose you have a list of students with their scores in a particular paper, and you want to cross-check against a separate list to identify which students did not show up for the exam.

A combination of IF, VLOOKUP, and ISNA can be used to find this:

  • Step 1: Enter the names of students you want to check starting from Cell B14.

  • Step 2: In the adjacent column (C14), enter the following formula:
=IF(ISNA(VLOOKUP(B14, $B$4:$C$9, 2, 0)), "Student didn’t show up")

  • Step 3: Drag the formula down for all the cells.

  • Step 4: Refresh the formulas to see the results.

If the student is part of the original list with grades, you should see ‘FALSE’ as the output. The ISNA function, in this case, returns either TRUE or FALSE based on whether the condition is satisfied.

use ISNA function
How to use ISNA function in Google Sheets

Learn how to do this step-by-step in the video below 👇

Automate financial reporting with LiveFlow

Cta Photo

Want to eliminate manual updates of your Excel & Google Sheets models?

Yes, show me how!

Get personal help

We guarantee you personal help on chat or Zoom within maximum 6 hours between 9am and 10pm EST.
Blue Tick
Email us at: help@liveflow.io

Liked this article? Then you'll love the ones below

Supercharge your financial reporting today

See LiveFlow in action and discover how to streamline your workflows.