Using the IsEmpty Function to Check Whether a Cell Is Empty

The IsEmpty function returns a Boolean value of whether a single cell is empty or not; True if empty, False if not. The cell must truly be empty. Even if it has a space in it, which you cannot see, Excel does not consider it empty:

IsEmpty(Cell)

Look at Figure 3.5. You have several groups of data separated by a blank row. You want to make the separations a little more obvious.

Figure 3.5

Blank empty rows separating data.

0 0

Post a comment