Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

It is in principle impossible. The return value of a formula is shown in the very same cell, which contains the formula. And because this cell contains the formula it is never "empty". Otherwise a formula would erase itself.

If the empty string is a valid result and you need to indicate, that the formula result is not valid, then you can use the function NA(). It generates the special error value #N/A, which can be tested by the function ISNA().

If you need to erase the content of a cell dependent on the values of other cells, you need a macro to do that.