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

excel insert a columnconcatenate excellformula to calculate difference between two dateshow to run macro in excelexcel vba range clearvba charremove blanks in excelexcel vlookup nainterviews questions and answers for freshersmicrosoft office excel 2007 templatesvba lookupdashboard powerpoint template freevba remove passwordhyperlinks examplesexcel vba rename filecreate formula in excel vbavba formulasql query operatorswriting vba codecopy a worksheet in excelhow to use vlookup in excel 2010 step by stepvlookup examples in excel 2007how to use sum if formulahighlight a column in excelmicrosoft excel vba programming for the absolute beginnerstacked pie chart excelrange vbasave excel file vbaexcel loop through rowslookup excel 2007hide columns exceladd developer tab to ribbon microsoft wordhow to remove duplicates in excel 2007interview questions on sql pdfexcel hide columns based on cell valuecreating a pie chart in excel 2010vlookup excel worksheetsorting formula in excelarray length in vbavba excel codehow to delete a row in excel using vbamultiple vlookup criteriahow to create excel dashboard reportshow many rows and columns in excel 2010countif functions in excelhow to delete a row in excel using vbaexcel sql tableconditional macroscommand button vba excelunhide a column in excelhow to hide lines in excelsql for beginnershow to delete duplicate values in excelvba save excelexcel vba range arrayexcel offset vbasimple dashboard in excelhow to search for blank cells in excelactivate workbookcreate dashboards in excelvba appmake pivot table excelenable macros vbaloop excel vbavba to printinsert blank rows in exceluses of vbaselection vba excelexcel formulas shortcutsvba excel codingexcel vba current worksheet