<< Click to Display Table of Contents >> IFEMPTY (return a value if cell is empty)

Syntax:

IFEMPTY(Cell, Value)

Description:

This normally returns the content of the Cell. If this cell is empty, however, the defined Value is returned instead.

Compatibility notes:

This function does not exist in Microsoft Excel. If you save a document in Excel format, all calculations using this function will be replaced with their current result as a fixed value.

Example:

IFEMPTY(A1, "Cell is empty!") returns the content of cell A1 as long as it is not empty. For an empty cell, however, the entered text string "Cell is empty!" is returned instead.

See also:

ISBLANK, IFERROR, IFNA