Blank Out Function Totals

[Neil Greenough]

I have the following function in cell E7 in a spreadsheet:

=D7-C7

Now, if there is no data in D7 and C7, then 00:00 appears in cell E7 as it
has no data to work against.

What I want to do is to blank out the cells with functions in them so that
they appear empty, unless initial data is entered. So in the above case, I
don't want anything to appear in cell E7 until cells D7 and C7 have been
populated.

Any ideas?

 

[Niek Otten]

Tools>Options>View, uncheck Zero values

 

[Paul B]

Neil, here is another way, put in E7

=IF(OR(ISBLANK(C7),ISBLANK(D7)),"",D7-C7)

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

 

[Neil Greenough]

Many thanks both of you

Neil, here is another way, put in E7

=IF(OR(ISBLANK(C7),ISBLANK(D7)),"",D7-C7)

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

 

[Pete]

Another way is conditional format - set foreground colour to white
(assuming this is the background colour) if the value equals zero.

Pete