some plug-in for Excel cannot recognize "" as a blank
cell.

That's because the cell is NOT blank and contains a formula.

I prefer to have formulas return Zero over empty text as Zeros are numeric
and can be easily hidden.

Perhaps you question should detail what you want to do?


--
Regards
Dave Hawley
www.ozgrid.com
"Eric" wrote in message
...
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