Microsoft Office Tutorials and References
In Depth Information
Finding What IS and What IS Not
The errors Excel reports are not very friendly. What on earth does #N/A
really tell you? The functions I describe in this section won’t make the error
any clearer, but they give you a way to instead display a friendly message like
“Something is wrong, but I don’t know what it is.”
Table 15-4 shows the IS functions and how they’re used. They all return
either True or False, so the table just lists them.
Table 15-4
Using the IS Functions to See What Really Is
Function
Comment
=ISBLANK(value)
Tells whether a cell is blank.
=ISERR(value)
Tells whether a cell contains any error other
than #N/A .
=ISERROR(value)
Tells whether a cell contains any error.
ISEVEN(value)
Tells whether a number is even.
=ISLOGICAL(value)
Tells whether value is logical.
=ISNA(value)
Tells whether a cell contains the #N/A error.
Tells whether a cell contains a number or error.
=ISNONTEXT(value)
Tells whether a cell contains a number.
=ISNUMBER(value)
Tells whether a number is odd.
ISODD(value)
=ISREF(value)
Tells whether value is a reference.
=ISTEXT(value)
Tells whether a cell contains text.
ISERR, ISERROR, and ISNA
Three of the IS functions — ISERR, ISERROR, and ISNA — tell you about
an error.
Error Function
ISERR
Returns true if the error is anything except the #N/A
error. For example, the #DIV/0! error returns true.
ISNA
The opposite of ISERR. It only returns true if the
error is #N/A.
ISERROR
Returns true for any type of error. This includes
#N/A, #VALUE!, #REF!, DIV/0!, #NUM!, #NAME?,
and #NULL!.
Search JabSto ::

Custom Search