ISNA Function in Excel

Home/Excel Formulas/ISNA Function in Excel

What is the use of ISNA function?

ISNA Function in Excel returns TRUE if the given value is #NA, otherwise returns FALSE

PREMIUM TEMPLATES LIMITED TIME OFFER

ON SALE80% OFF

50+ Project Management Templates Pack
Excel PowerPoint Word

Advanced Project Plan & Portfolio Template
Excel Template

Business Presentations Templates Pack
PowerPoint Slides

20+ Excel Project Management Pack
Excel Templates

20+ PowerPoint Project Management Pack
PowerPoint Templates

10+ MS Word Project Management Pack
Word Templates


What is the syntax of ISNA function?

ISNA Function in Excel - Syntax

ISNA( value)

value : value to be checked

ISNA Function in Excel – Examples

ISNA Function in Excel - Example 1

Example 1: Returns FALSE as the given value is not #NA
Example 2: Returns FALSE as the given value is not #NA
Example 3: Returns FALSE as the given value is not #NA
Example 4: Returns TRUE as the given value is #NA

Reference:

Please refer the below article for more Information Excel functions.
Information Excel Formulas

Please refer the below article for more Excel Functions.
Excel Formulas | Home

LIMITED TIME OFFER
By |March 23rd, 2013|Excel Formulas|0 Comments

About the Author:

Excel VBA Developer having around 8 years of experience in using Excel and VBA for automating the daily tasks, reports generation and dashboards preparation. Valli is sharing to helps us automating daily tasks.

Leave A Comment


Related pages


match function in vbatextbox in vbavbscript write to text filewindows.activate vbavba code msgboxdata analyst interview questions and answers pdffso.fileexistsexcel vba sql server connection stringsql query excel vbavba advanced filterexcel project plan template microsoftaccess vba updatedml and ddl commands in sql servervba and macros for microsoft excelcombining worksheets in excelpivottable in excelsql interview questions advancedexample of excel formulasexcel templates for project trackingmerge and center the selected cellsmacro to combine multiple workbooks into oneexample of vlookup formulaexcel vba listboxspotfire tutorialvariant vbaexcel look for duplicateshow to merge data in excel from multiple worksheetsvba lower casecheck if workbook is open vbaunderstanding vbadelete rows in vbacreating dashboardsmerging rows in excelconvert excel sheet to xmlexcel 2013 merge cellsvba clear variableunhide columns in excel 2013what is dim in vbawhat is isna in excelexcel 2007 chart wizardedit excel macrosexcel integer functionaccess vba delete recordlookup function in excelmsgbox function in vbahow to learn vba codevba powerpointwriting macro in excelselect case statement vbacool macrosexcel merge sheets into oneexcel special characters in formulavba data validationvba formatclearcontents vbavb6 sql server connection stringfresher interview questions and answersunprotect excel sheet with passwordbuy excel templatesuse of vlookup in excel 2007sample excel vba projectsunprotect workbook macrostatus update template powerpointvba tutorials pdfhow do you delete extra pages in excelexcel formulas offsethow to remove protection from excel sheetplanning xls templatesrecord macro excelcreating macro in excel 2007vba connect to sql databasevlookup and isnavba buttonexcel tips for beginnerscombine excel tabs