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


excel in cell charthow to put columns in alphabetical order in excelaverageifs exampleexcel vba save as xlsxpowerpoint project status dashboard templateisblank formulavba copy rangevba folderexcel vba end subsum if formulashortcut key insert row excelexcel programme templateexcel formula correctorhow to teach excel for beginnersvba code for excel examplesexcel template dashboardexcel vba open fileuserform comboboxmultiple if statements in excel formulaexcel combo box macrohow to use sumif functionhyperlink on excelinsert tick box in excel 2007excel formula if cell contains text thenexcel sheet passwordvba repeat untilappend string in excelvba graphvba protect sheetcheckbox excel 2007construction timeline template excelexcel rows columnstimeline templates excelloops in excelexcel vba text boxexcel table remove duplicateshow to use hlookup in excel with examplevbscript example programsbar chart excel templatehow to open xlsx files in excel 2003vba print worksheethow to create a combobox in excel 2010vlookup and hlookup tutorialvba experienceprotect sheet excel vbahyperlink excel sheetproject tracker template in excelcreate input form in excel 2010userform command buttonms excel macros examplesexcel programming for beginnershow to find duplicates in excel 2007vba create email with attachmentexample for vlookup in excelexcel vba resizedeclare array in vbatime phased budget templatehow do i unhide rows in excel 2010delete row in excel shortcutvba userform initializehow to insert comment in excelexcel merge functionexcel vba formsvb cellspaste special excel 2007vba and macrosvba custom functiontotal no of rows and columns in excelhide formulas in excel 2007macros and vba in excelworkbook save vbaconvert excel to csv comma delimitedoffset command in excelproject charter sample templateexcel 2007 offset