ISBLANK Function in Excel

Home/Excel Formulas/ISBLANK Function in Excel

What is the use of ISBLANK function?

ISBLANK Function in Excel tests if given value or Cell is a Blank or not and returns TRUE if the value is blank;otherwise returns FALSE



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 ISBLANK function?

ISBLANK Function in Excel- Syntax

ISBLANK( value)

value : value to be checked

ISBLANK Function in Excel – Examples

ISBLANK Function in Excel- Example 1

Example 1: Returns the FALSE as the given value is not a Blank
Example 2: Returns the TRUE as the given value isa Blank
Example 3: Returns the FALSE as the given value is not a Blank
Example 4: Returns the FALSE as the given value is not a Blank


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

By |March 12th, 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

workbooks vbaappend text filescheck boxes in excelfinding duplicates in excelconcatenate excelmacro excel exampleexcel reverse vlookupudf vbaexcel graphs tutorialclear comboboxhow to put alphabetical order in excelhow to program a macro in excelvba form loadexcel vba message box yes nousing trim in excelvlookup usagecreating a scorecard in excelvba singlelistbox controlvba select workbookexcel table remove duplicatesexcel remove duplicates from columnexcel vba on cell changeisempty in vbahow to dedupe a list in excelunprotect excel workbook without passwordssis check if file existsdeduplicate excelexcel automatic row heighthow to unprotect excel sheet 2010 without passwordbooks on excel vbaunlock excel spreadsheet macrovba code to save workbookddl dml tclexcel vba transposecool excel chartsmeeting minutes excel templatemacros in sqlfind duplicates in excel vbavba getting startedcost analysis spreadsheet excelvba excel modulehard return in excelvba excel sumhow to unhide columns in excelvba function subextract hyperlink excelexcel 2007 dashboard tutorialif with multiple conditions excelevent project plan template excelexcel range macroexcel formula columniserror function in excel 2010simple cut and paste worksheetsexcel hidden workbookmacros in excel for beginnersvb dialog boxexcel protected workbook forgot passwordexcel vba close formexcel exercise for job interviewrecord macros in excelvlookup 2 criteriachar excelvba select rangeexcel vba global variableexcel dashboard and reportsexcel vba delete columnexcel dim as rangehow do i unhide cells in excelrun excel macro on opensaveas vbavba numberformatvba commandsremove duplicate cells in excel