Blank Out Function Totals

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
Sun Nov 27 07:58:30 CST 2005

Tools>Options>View, uncheck Zero values

--
Kind regards,

Niek Otten

"Neil Greenough" <scrivomc@hotmail.com> wrote in message
news:mFiif.82137$375.80579@fe3.news.blueyonder.co.uk...
>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?
>

Paul
Sun Nov 27 08:13:45 CST 2005

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" <scrivomc@hotmail.com> wrote in message
news:mFiif.82137$375.80579@fe3.news.blueyonder.co.uk...
> 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?
>
>

Neil
Sun Nov 27 10:23:37 CST 2005

Many thanks both of you

"Paul B" <to_much_spam_to_list@nospam.com> wrote in message
news:uc5BR118FHA.3952@TK2MSFTNGP12.phx.gbl...
> 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" <scrivomc@hotmail.com> wrote in message
> news:mFiif.82137$375.80579@fe3.news.blueyonder.co.uk...
>> 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?
>>
>>
>
>

Pete
Sun Nov 27 16:33:28 CST 2005

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

Pete