Microsoft Excel X for Mac OS X: Visual QuickStart Guide

Information Functions

Excel's information functions return information about other cells.

The IS functions

Excel's IS functions (Figure 73) use the following syntax:

              ISBLANK(value)               ISERR(value)              ISERROR(value)             ISLOGICAL(value)               ISNA(value)             ISNONTEXT(value)             ISNUMBER(value)               ISREF(value)              ISTEXT(value)

Figure 73. In this example, the IS functions were used (in the order shown to the right) to evaluate the contents of the cells in row 1 of the worksheet. The results of each function appear below the value.

In each case, Excel tests for ...