How to Install the Excel 2007 Analysis ToolPak
Depreciating Assets with Excel 2007's SLN, SYD, DB, and DDB Functions
Using Boolean Expressions in Data Analysis with Excel 2007

Using Excel 2007's IS Information Functions

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.

  • Add a Comment
  • Print
  • Share
blog comments powered by Disqus
An Overview of Excel 2007's Reference Functions
Fixing Capitalization with Excel 2007's UPPER, LOWER, and PROPER Functions
Planning Ahead with Excel 2007's TODAY, DATE, and DATEVALUE Functions
Looking Up Data in Excel 2007 with HLOOKUP and VLOOKUP
Deconstructing Time with Excel 2007's HOUR, MINUTE, and SECOND Functions
Advertisement

Inside Dummies.com