MS Excel: IsBlank Function

In Excel, the IsBlank function can be used to check for blank or null values.

The syntax for the IsBlank function is:

IsBlank( value )

value is the value that you want to test. If value is blank, this function will return TRUE. If value is not blank, the function will return FALSE.

Applies To:

Excel 2007, Excel 2003, Excel XP, Excel 2000

For example:

Let's take a look at an example:

Based on the Excel spreadsheet above:

=IsBlank(A1) would return FALSE

=IsBlank(A2) would return TRUE

=IsBlank("Tech on the Net") would return FALSE