Microsoft Excel 2003 Functions and Formulas
Determine if a Particular Cell is Blank
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")
For example:
A1: $29.25
A3: 117 Quarters
A1: $542.75
A3: 2171 Quarters
A1:
A3: No Dollar Amount Provided
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: