Summary: Determine whether or not a particular cell contains any information.
In Microsoft Excel 2003, you can use the =countblank function to determine how many cells in a particular range are blank.
What if you only want to determine whether or not a particular cell contains any information?
=isblank(CELL)
CELL is the cell that you wish to check.
For example, in this spreadsheet, cell A1 will contain a user-inputted US dollar figure. Cell A3 converts the value to quarters, or displays "No Dollar Amount Provided" if no values were inputted into cell A1.
A
1 user input
2
3 =IF(ISBLANK(A1),"No Dollar Amount Provided",A1*4 & " Quarters")
Add: Del.icio.us |
Digg |
Furl |
My Yahoo!
Last Modified on: August 26, 2008, at 8:28 A.M. EDT
Return to the Microsoft Excel 2003 Functions and Formulas page.
Search the Site: