Louise

Would ToolsOptionsView uncheck "Zero Values" work for you?


Gord Dibben MS Excel MVP

On Thu, 3 May 2007 03:34:02 -0700, Louise
wrote:

Hi
Thanks for the help.

If I want this to be applied to every cell in the worksheet though, where
would the IF statement go??

Louise

"FSt1" wrote:

hi,
formating will not do that. all formating does is change the way data looks
on the sheet. It does not change the data nor can it make decisions based on
conditions.
try a formula like this.....

=IF(SUM(D1:D3)=0,"",SUM(D1:D3))

regards
FSt1

"Louise" wrote:

Hi all

I have formulas on my worksheet and several of the 'answers' are zero, which
is correct, however, I want to format the whole worksheet so rather than
displaying '0', it simply leaves the cell blank.

How would I do this?

Thanks.
Louise