Blank Out Function Totals

  • Thread starter Thread starter Neil Greenough
  • Start date Start date
N

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?
 
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
 
Many thanks both of you

Paul B said:
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
Click to expand...
 
Another way is conditional format - set foreground colour to white
(assuming this is the background colour) if the value equals zero.

Pete
 
Back
Top