You can use an "if" statement. It's not exactly addressing being blank
if unused, but rather if the result (or an input cell) is 0 or blank.
=if(formula=0,"",formula)
"If the result my formula = 0, then put nothing in the cell, otherwise
use my formula"
or
=if(cell=0,"",formula)
"If the input cell =0, then put nothing in the cell, otherwise use my
formula".
As far as I can tell, conditional formulas will allow you to change
the font/color/appearance of a cell based on a result, but not leave
it blank. Of course, you could select a font color that matches the
background color.
On another note, I sure hope you post your solution to the great
delays you see when opening MS products or right-clicking in Windows
Explorer. I've got a very similar problem, though Win2k. FWIW, I've
used F-Prot, housecall.trendmicro.com, SpyBot, and AdAware, and the
system comes up clean each time.
I am using Excel Office 97 Professional Edition and working on a worksheet
that has several entered formulas. Presently a "0" appears in each of these
cells and I would like it to appear blank unless used. I've been told it can
be done, can anyone help? Thanks very much!
Soloman10
=============
- Dale Gombert (SkySea at aol.com)
122.38W, 47.58N, W. Seattle, WA
http://flavorj.com/~skysea