RSS

ISBLANK()

05 May
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.
Advertisements
 
Leave a comment

Posted by on May 5, 2012 in MS Excel, My Home

 

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

 
%d bloggers like this: