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")
Press the "print" button on your browser or select "File" - "Print" to print this tip. Then, return to Microsoft Excel 2003 Functions and Formulas - Determine if a Particular Cell is Blank.
Standard disclaimer applies - Read http://tipsforspreadsheets.com/copyright-disclaim.html.