Home

Microsoft Excel [email protected]

Microsoft Excel 2007

Microsoft Excel 2003

Forums

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.

Print this tip.

- Subscribe!

Search the Site: