Temporarily hiding cell values.

[Paul Blarmy]

I have a simple spreadsheet for my daughter to use to keep track of her
savings account. The only data entries she makes are the date (column B),
the details (column C) and then a monetary amount for either a deposit
(column D) or a withdrawal (column E). Column F keeps a running total of
the balance using (=F5+D6)-E6, (=F6+D7)-E7 etc...

This works fine, however, column F is then filled with the current
balance right the way down to the end of the spreadsheet (or at least
until where I have carried on with the formula). What I would like to do
is to have column F remain blank after the most recent transaction line.

Is there a way to leave the formula in column F intact but to specify
that unless there is (for example) a date in column B10 then the contents
of column F10 will remain invisible?

Thanks very much.

 

[Frank Kabel]

Hi
use something like
=IF(B10="","",your_formula")

 

[Paul Blarmy]

On Sun, 5 Sep 2004 09:44:20 +0200, Frank Kabel wrote...

=IF(B10="","",your_formula")

Thanks for the reply, but this isn't doing anything in my sheet. Maybe I
am not entering it as I should? I am putting into cell F6:

IF(B6="","",=(F5+D6)-E6)

If cell B6 is empty then I want cell F6 to show empty too - otherwise if
cell B6 has an entry, cell F6 should show the result of =(F5+D6)-E6)

Thanks again for any further assistance you may be able to give.

 

[Frank Kabel]

Hi
use
IF(B6="","",(F5+D6)-E6)

 

[Paul Blarmy]

On Sun, 5 Sep 2004 10:31:25 +0200, Frank Kabel wrote...

Hi
use
IF(B6="","",(F5+D6)-E6)

Hi Frank

Thanks for your help, but this isn't working either. All I get is the
following:

IF(B6="","",(F5+D6)-E6)

showing in the actual cell as if it were just a standard text entry
rather than a formula.

 

[Paul Blarmy]

On Sun, 5 Sep 2004 09:48:22 +0100, Paul Blarmy wrote...

Thanks for your help, but this isn't working either. All I get is the
following:

<homer simpson>
D'oh!
</homer simpson>

I had missed off the opening '=' sign.

Thanks for your help and your patience Frank