Microsoft Office Tutorials and References

In Depth Information

**Using IS Functions to Test for Types of Values**

Using

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

value:

•
ISBLANK

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

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.

Note

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

=ISEVEN().

•
ISODD

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

ISLOGICAL
—
This function indicates whether the value is TRUE,

FALSE, or an expression that results in TRUE or FALSE.

•
ISTEXT

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.