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


formula vlookup excel 2007activate a workbooksas basics tutorialhow do i unhide a column in excelexcel repeat last actionisna functionvba booleanhow to put drop down list in excel 2007nested if function excel 2010how to delete rows and columns in excelvba indentcreating dynamic charts in excelactivex combo boxproject management excel dashboardsales dashboard examples excelms excel tutorial with exampleshow to avoid duplicates in excelunprotect excel filemultiple conditions excelsample project budget spreadsheetvba macro codingvba code to connect to access database from excelhow to use the countif function in excel 2013vba create access databaseexcel cell value to stringexcel sheet macroscreate a pivot chart in excel 2010sample excel spreadsheet for practiceconsolidated worksheetexcel macro codinginsert row excel 2007how to delete a cell in excelsample project timeline templateexcel insert rows shortcutvba specialcellsexcel highlight duplicate cellschart wizard on excelstep by step vlookupclose userform vba excelexcel bar chart widthhow to password protect a spreadsheetautomation testing interview questions and answers pdf free downloadtelecom testing interview questions answers pdfexcel vba copy and pastesorting formula in excelexamples of dashboards in excelhow to create if statements in excelrow in excel definitioncreate userform in excel 2007sas miner tutorialwhat is the developer tab in wordvba workbook objectmicrosoft excel vlookup formulaexcel vba cells valuelistbox additemvba column widthdata mining interview questions and answerscut and paste workbooksvba activeworksheetsample sql queries for interviewexcel vba create rangeactivate workbooksql query in excelsumif excelexcel dynamic graphadvanced excel dashboardsvba vbcriticalwhat are vlookups in excelproject update template pptcount filled cells in excelweekly report template pptadodb referencepivot table excel 2003 tutorialexcel practice filesexcel tutorials advancedinstr function in excelhow to create macros in excelunlock vba codeexcel userform codebreak loop in vbavariables vbaexcel vba xmlpivot table explainedhow to find duplicate rows in excelunprotect excel sheet onlinemonthly schedule template excelmacro programming in excel