Microsoft Office Tutorials and References
In Depth Information
Using IS Functions to Test for Types of Values
Using IIS Functions to Test for Types of Values
Functions to Test for Types of Values
Figure 12.12 shows the results for the seven remaining IS functions. Each
of these functions reveals whether a cell contains a particular type of
ISBLANK — This function returns TRUE only if a cell is completely
empty. A cell that contains several spaces is not considered blank.
Even a cell that contains a single apostrophe and no spaces is not
considered blank by the ISBLANK function. It would have been more
appropriate if the folks at Lotus 1-2-3 would have called this the
@IsEmpty function, but you are stuck with the bad name now that it
has been in use forever.
ISEVEN — This function indicates whether a number is evenly divis-
ible by 2. Note that cell A8 is an empty cell, which is considered zero
and reports as even. Using a date as the value in ISEVEN returns a
value, but that value does not make sense. Using text or logical val-
ues in the ISEVEN function causes a #VALUE! error.
Mathematicians in the audience might suggest that you could just
as easily use =MOD(A2,2)=0 to figure out whether a number is even.
However, unless you are a mathematician, it is far easier to remember
ISODD — This function indicates whether a number is not evenly di-
visible by 2. An empty cell is considered zero and returns FALSE to
ISODD. The same limitations listed for ISEVEN apply to ISODD. In addi-
tion, if your value contains decimal places, they are ignored by both
the ISEVEN and ISODD functions. Numbers such as 1.02, 1.2, 1.5, 1.9, and
1.99999999 all return TRUE for the ISODD function.
ISLOGICAL — This function indicates whether the value is TRUE,
FALSE, or an expression that results in TRUE or FALSE.
ISTEXT — This function returns TRUE if the value contains text. This
is good for finding values such as ABC in cell A16 and for finding
cells that look like numbers but are actually stored as text.