Microsoft Office Tutorials and References

In Depth Information

**Finding What IS and What IS Not**

Error Function

Comments

ISBLANK

Returns true if the cell is empty. Returns false

otherwise.

ISNONTEXT

Returns true if the cell contains anything that is not

text: a number, a date/time, or an error. Also returns

true if the cell is blank. Returns false if the cell contains

text or a formula whose result is text.

ISTEXT

The opposite of ISNONTEXT: Returns true if the cell

contains text or a formula whose result is text. Returns

false otherwise.

ISNUMBER

Returns true if the cell contains a number or a formula

whose result is a number. Returns false otherwise.

ISBLANK returns true when nothing is in a cell. Using ISBLANK is useful to

count how many cells in a range are blank. Perhaps youâ€™re responsible for

making sure that 200 employees get their timesheets in every week. You can

use a formula that lets you know how many employees have not yet handed

in their hours.

Such a formula uses ISBLANK along with the IF and SUM functions, like this:

{=SUM(IF(ISBLANK(B5:B26),1,0))}

This formula makes use of an array. See Chapter 3 for more information on

using array formulas. Figure 15-5 shows how this formula works. In columns

A and B are lists of employees and their hours. The formula in cell A1 reports

how many employees are missing their hours.

Figure 15-5:

Calculating

how many

employees

are missing

an entry.