The ISBLANK function’s job is to check to see if a certain cell is empty or not. If the cell is empty, a value of TRUE is returned by the function.
If data is later added to an empty cell the function will automatically update and return a FALSE value.
The syntax for the ISBLANK function is:
= ISBLANK ( Value )
Value: Refers to the cell reference that is being checked.
Example Using Excel’s ISBLANK Function:
For help with this example, see the image to the right.
- Type a number, such as ” 3 “, or a word of text into cell.
- Click on cell – the location where the results will be displayed.
- Click on the Formulas tab.
- Choose More Functions > Information from the ribbon to open the function drop down list.
- Click on ISBLANK in the list to bring up that function’s dialog box.
- Click on cell, in the spreadsheet to enter the cell reference into the dialog box.
- Click OK.
- The value FALSE should appear in the resulted cell, because value cell is not empty.
- The complete function = ISBLANK ( cell ) appears in the formula bar above the worksheet when you click on cell.
- To return a value of TRUE in cell, delete the data in value cell or change the cell reference in the function to a cell that is empty.