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