|
<< Click to Display Table of Contents >> IFEMPTY (return a value if cell is empty) |
Syntax:
IFEMPTY(Cell, Value)
Description:
Normally returns the content of the Cell. However, if this cell is empty, the defined Value is returned instead.
Compatibility notes:
This function is not supported by Microsoft Excel. If you save a document in Excel format, all calculations using this function will be replaced by their last 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: