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.
Search JabSto ::




Custom Search