ISBLANK()

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.
  1. Type a number, such as ” 3 “, or a word of text into cell.
  2. Click on cell – the location where the results will be displayed.
  3. Click on the Formulas tab.
  4. Choose More Functions > Information from the ribbon to open the function drop down list.
  5. Click on ISBLANK in the list to bring up that function’s dialog box.
  6. Click on cell, in the spreadsheet to enter the cell reference into the dialog box.
  7. Click OK.
  8. The value FALSE should appear in the resulted cell, because value cell is not empty.
  9. The complete function = ISBLANK ( cell ) appears in the formula bar above the worksheet when you click on cell.
  10. 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.

Leave a Reply

Your email address will not be published. Required fields are marked *