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:
Where the supplied value argument is a reference to a cell.
The spreadsheet below shows examples of the Excel Isblank function, used to determine whether a cell is empty or not.
|
Formulas:
|
Results:
|
For further details and examples of the Excel 'Is' functions, see the Microsoft Office website.