1-855-939-2357 Get Quote Now

ISBLANK
Other Data Type Functions

Basic Description

The Excel Isblank function tests if a specified cell is blank (empty) and if so, returns TRUE; Otherwise the function returns FALSE.

The syntax of the function is:

ISBLANK( value )

Where the supplied 'value' argument is a reference to a cell.

Isblank Function Examples

The spreadsheets below show examples of the Excel Isblank function, used to determine whether a cell is empty or not. The formulas are shown in the spreadsheet on the left and the results are shown in the spreadsheet on the right:

 Formulas:
 AB
1 10 =ISBLANK( A1 )
2 text =ISBLANK( A2 )
3   =ISBLANK( A3 )
 Results:
 AB
1 10 FALSE
2 text FALSE
3   TRUE

 

Excelq.com doing business as a Service of Venttraffic Media Inc. Excel and other words on this site may be trademarks or registered trademarks of Microsoft Corporation. Microsoft Corporation is not connected in any way with this website, and makes no endorsement of the site or its related contents. All rights reserved. Website powered by Venttraffic Media Inc.