Microsoft Office Tutorials and References
In Depth Information
IS Functions
B
As a cell reference
Figure 7.4
The INFO function can
provide quick
information about a system or
operating environment
including certain Excel
settings.
1
As text
IS Functions
=ISFUNCTION(NUMBER)
Keep in mind that the function portion is replaced by one of the IS functions options in the syntax.
The IS functions return logical results after a test on a cell or a range of cells. These
functions alone provide the logical test. However, when combined with other functions like the IF
function, they become a powerful decision making tool for analyzing data and returning a
logical test with a numeric result. The following IS functions in Table 7.4 are available in Excel.
Table 7.4
IS Function Returns
IS Function
Returns True If…
The value refers to blank cells
ISBLANK
The value refers to an error type, except #NA
ISERR
The value refers to any error value
ISERROR
The value returns True if the number is even, False if not
ISEVEN
The value refers to a logical value
ISLOGICAL
The value refers to the #NA error value (value not available)
ISNA
The value refers to any item that is nontext (returns True on blank cells)
ISNONTEXT
The value refers to a number
ISNUMBER
The value returns True if the number is odd, False if not
ISODD
The value refers to a reference
ISREF
The value refers to text
ISTEXT
Search JabSto ::




Custom Search