Using Information Functions
Similar to the logical functions, the information functions serve to supplement and support other functions and formulas.
At the center of the information functions are the so-called IS functions (see Table 2-2), which provide information about expression types or the cell content. This information can be viewed or, more usefully, used for other calculations. The names of these functions are self-explanatory, and the returned values are always logical values. The logical value confirms whether the value of the cell specified in the argument is of the required type. Usually the argument for the functions is a cell reference, but sometimes—for example, for the ISREF() function—a specific value is provided for testing. ...
Get Microsoft® Excel® 2010 Formulas & Functions Inside Out now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
