This tip was printed from the Tips for Spreadsheets website at http://tipsforspreadsheets.com/.

Microsoft Excel 2003 Functions and Formulas - Determine if a Particular Cell is Blank

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



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.