FORMULA function

From Apache OpenOffice Wiki
Jump to: navigation, search
The printable version is no longer supported and may have rendering errors. Please update your browser bookmarks and please use the default browser print function instead.

ISBLANK

Tests if the cell is blank (empty).

Syntax:

ISBLANK(cell)

Returns TRUE if cell is a blank (empty) cell, and FALSE otherwise. Cells containing a formula or a error return FALSE.

Example:

ISBLANK(D2)

returns TRUE if D2 is an empty cell, and FALSE if D2 contains a number, text, TRUE, FALSE, a formula or an error.



See Also

Personal tools
In other languages