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

add developer tab excel 2013isempty excel vbagraph creation in excelvba checkboxlookup functions excelloop function vbavba code snippetsexcel macro graphexcel reports and dashboardsedit vba code in excelwhat is a hyperlink in excelvba sql excelaccess msgboxvba adodb connection referencemultiple conditions in excelvba update status barvba excel isnumberifs excelexcel vba testc programming interview questions answers and explanationsvba save pdfhow to deduplicate in excelvelocap excelaccess vba odbc connection string sql serverprogress chart excel templatefreshers technical interview questionsms access vba msgboxexcel macro applicationfilesystemobject opentextfilehow to lock an excel workbookhow do i delete blank rows in excel 2010how to delete duplicates in excel 2010excel hide rowsdefinition of row and column in ms excelrecord macros in excelexcel vba codevba torrentif formula in excel 2007 with exampleexcel insert row with formuladaily task sheet template excelexcel hard returnhow to write a conditional statement in excelremove blank from pivot tabledim fsodelete activexiferror vlookup excelhow to create a vlookup in excel 2007ms excel basics tutorialword 2013 developer tabexcel offset functionrange variable vbaunhide exceloutlook macro examplesvba code to clear cellstask tracking excel templatearea charts in excelvba experiencevba access open formuse of vlookup in excel 2010data validation in excel 2010 tutorialexcel vba sort rangehow to insert a checkbox in excelvb exit for loopexcel sort column alphabeticallydeclaring variables in vbahlookup and vlookup in excel 2007 with exampletwo if statements in one cell excelhlookup excel functionuserform vbaexcel macro rename worksheetexcel match formulaexcel macro arrayexcel vba userform tutorialexcel combo box macroexcel unhide sheets