{"id":1314,"date":"2018-07-04T10:23:02","date_gmt":"2018-07-04T10:23:02","guid":{"rendered":"http:\/\/officetuts.net\/excel\/?p=1314"},"modified":"2023-11-03T10:03:43","modified_gmt":"2023-11-03T10:03:43","slug":"isna","status":"publish","type":"post","link":"https:\/\/officetuts.net\/excel\/functions\/isna\/","title":{"rendered":"ISNA function"},"content":{"rendered":"\n
Excel’s ISNA function is a useful tool for checking if a cell contains the #N\/A error value. This error typically appears when a lookup function can’t find the desired value in a range. ISNA returns “TRUE” if the specified cell contains #N\/A, and “FALSE” if it doesn’t. Let’s break down the function in simple terms for easy understanding.<\/p>\n\n\n\n
ISNA(value)<\/strong><\/p>\n\n\n\n The ISNA function is straightforward to use. You provide the cell or formula result you want to check for the #N\/A error as the ‘value’ argument. Here are a couple of examples:<\/p>\n\n\n\n Example 1:<\/strong> Checking if cell A1 contains #N\/A.<\/p>\n\n\n\n This formula will return “TRUE” if cell A1 contains #N\/A, and “FALSE” if it doesn’t.<\/p>\n\n\n\n Example 2:<\/strong> Using ISNA with a VLOOKUP function.<\/p>\n\n\n\n Here, ISNA is used to check if the VLOOKUP function returns #N\/A when searching for “SearchValue” in the range A1:B10. It will return “TRUE” if a #N\/A error occurs and “FALSE” if it doesn’t.<\/p>\n\n\n\n The ISNA function is handy for error handling in Excel. It allows you to quickly identify and address #N\/A errors in your spreadsheets. If you encounter other error values, such as #VALUE! or #REF!, Excel offers similar functions like ISERR and ISERROR to handle those cases.<\/p>\n","protected":false},"excerpt":{"rendered":" Excel’s ISNA function is a useful tool for checking if a cell contains the #N\/A error value. This error typically appears when a…<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[25],"tags":[180],"yoast_head":"\nArguments<\/h2>\n\n\n\n
value<\/strong><\/td> The value you want to check for the #N\/A error. This argument is required.<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n How to Use<\/h2>\n\n\n\n
=ISNA(A1)<\/code><\/pre>\n\n\n\n
=ISNA(VLOOKUP(\"SearchValue\", A1:B10, 2, FALSE))<\/code><\/pre>\n\n\n\n
Additional Information<\/h2>\n\n\n\n