Excel 2007's IS information functions (as in ISBLANK, ISERR, ISNA, ISNUMBER, ISTEXT, and so on) are a large group of functions that perform essentially the same task. They evaluate a value or cell reference and return the logical TRUE or FALSE, depending on whether the value is or isn’t the type for which the IS function tests. These functions are located in the Logical category on the Formulas tab of the Ribbon and in the Insert Function dialog box.
For example, if you use the ISBLANK function to test the contents of cell A1, as in
=ISBLANK(A1)
Excel returns TRUE to the cell containing the formula when A1 is empty and FALSE when it’s occupied by any type of entry.
Excel offers nine built-in IS information functions:
ISBLANK(value) evaluates whether the value or cell reference is empty.
ISERR(value) evaluates whether the value or cell reference contains an Error value (not including #NA).
ISERROR(value) evaluates whether the value or cell reference contains an Error value (including #NA).
ISLOGICAL(value) evaluates whether the value or cell reference contains a logical TRUE or FALSE value.
ISNA(value) evaluates whether the value or cell reference contains the special #N/A Error value.
ISNONTEXT(value) evaluates whether the value or cell reference contains any type of entry other than text.
ISNUMBER(value) evaluates whether the value or cell reference contains a number.
ISREF(value) evaluates whether the value or cell reference is itself a cell reference.
ISTEXT(value) evaluates whether the value or cell reference contains a text entry.
In addition to these nine IS functions, Excel adds two more, ISEVEN and ISODD, when you activate the Analysis ToolPak add-in. The ISEVEN function evaluates whether the number or reference to a cell containing a number is even, whereas the ISODD function evaluates whether it is odd.
dummies
Source:http://www.dummies.com/how-to/content/using-excel-2007s-is-information-functions.html
No comments:
Post a Comment