I don't think there is some universal way short of 'Clear contents' - and I
hope you don't consider it as an option :-)

Really, when you have a formula in cell, it never is empty - whatever the
formula returns, there is the formula itself too!



Arvi Laanemets.


"Eric" kirjutas sõnumis news:
...
If condition does not meet, then nothing in cell, which I use "" to define
blank cell, however, some plug-in for Excel cannot recognize "" as a blank
cell.
Does anyone have any suggestions on another approach to define blank
within
formula?
Thanks in advance for any suggestions
Eric