Excel -Office 97 - Professional Edition

[Soloman10]

HELP . . . I have entered a number of formulas into specific cells which keep
a running total. In each cell, "0" appears and I would like the cell to
appear blank if no math calculation has been made to that cell. I've been
told it can be done . . . can anyone help? Thanks very very much.
(e-mail address removed)
Tom W. (ô¿ô)

 

[Carey Frisch [MVP]]

Please visit the experts in the Excel newsgroup:
news://msnews.microsoft.com/microsoft.public.excel

or

Discussions in Excel General Questions
http://www.microsoft.com/office/com...?dg=microsoft.public.excel.misc&lang=en&cr=US

--
Carey Frisch
Microsoft MVP
Windows - Shell/User
Microsoft Community Newsgroups
news://msnews.microsoft.com/

-------------------------------------------------------------------------------------------

:

| HELP . . . I have entered a number of formulas into specific cells which keep
| a running total. In each cell, "0" appears and I would like the cell to
| appear blank if no math calculation has been made to that cell. I've been
| told it can be done . . . can anyone help? Thanks very very much.
| Tom W. (ô¿ô)

 

[Bob I]

See conditional formatting

 

[Harlan Grove]

Soloman10 wrote...

HELP . . . I have entered a number of formulas into specific cells which keep
a running total. In each cell, "0" appears and I would like the cell to
appear blank if no math calculation has been made to that cell. I've been
told it can be done . . . can anyone help? Thanks very very much.

The difficulty is that if your calculations could produce zero as a
valid result, using custom number formats or conditional formatting to
hide default zeros would also hide calculated zeros. If there's a way
to detect that default zeros were defaults, then use such tests as
conditional arguments to IF function calls, e.g.,

C5:
=IF(COUNT(B$2:B5),SUM(B$2:B5),"")