Isblank, 160 isblank – Apple iWork '09 User Manual
Page 160
Examples
If B1 is a number value and D1 evaluates to 0, then:
=IFERROR(B1/D1,0) returns 0 since division by zero results in an error.
=IF(ISERROR(B1/D1),0,B1/D1) is equivalent to the previous IFERROR example, but requires the use of
both IF and ISERROR.
=IF(IFERROR(OR(ISEVEN(B4+B5),ISODD(B4+B5), FALSE),), “All numbers”, “Not all numbers”) returns the
text “All numbers” if both cells B4 and B5 contain numbers; otherwise the text “Not all numbers.” This
is accomplished by testing to see if the sum of the two cells is either even or odd. If the cell is not a
number, the EVEN and ODD functions will return an error and the IFERROR function will return FALSE;
otherwise it will return TRUE since either EVEN or ODD is TRUE. So if either B4 or B5 is not a number
or a Boolean, the IF statement will return the if-false expression, “Not all numbers”; otherwise it will
return the if-true expression “All numbers.”
Related Topics
For related functions and additional information, see:
“Listing of Logical and Information Functions” on page 155
“Value Types” on page 36
“The Elements of Formulas” on page 15
“Using the Keyboard and Mouse to Create and Edit Formulas” on page 26
“Pasting from Examples in Help” on page 41
ISBLANK
The ISBLANK function returns TRUE if the specified cell is empty and FALSE otherwise.
ISBLANK(cell)
Â
cell: A reference to a single table cell. cell is a reference value to a single cell that
can contain any value or be empty.
Usage Notes
If the cell is completely blank (empty), the function returns TRUE; otherwise it
Â
returns FALSE. If the cell contains a space or a nonprinting character, the function
will return FALSE, even though the cell appears to be blank.
160
Chapter 7
Logical and Information Functions