How do I stop totals showing from a copied formula?

[Gossipsfrolick]

I've created a simple spreadsheet for a friend on which to do her home
accounts. I want to make it as automated as possible while keeping it simple
to add entries.

The columns on which calculations will be based are headed:

C D E
Withdrawal Paid In Balance

Entries into the Withdrawal column will be made as a negative number. I've
created a formula whereby a new balance is created by adding the values in C
and D to the balance in column E from the previous row. e.g. =(E5+C6+D6).

My problem is this. So far I have data and values inserted in rows 4 to 11
and have copied the formula down the cells in column E. Once I copy it
beyond the rows with information, it continues to show the same value as
that in cell E11. Is there anyway in which these values can be hidden until
they are the result of calculations from each row? Sorry if that's not
explained very well. It's difficult to do it succintly.

Any help would be appreciated. Thank you

Gillian

 

[Ragdyer]

One way:

=IF(AND(C6="",D6=""),"",C6+D6+E5)

 

[Gossipsfrolick]

Thank you. It worked!

Gillian

One way:

=IF(AND(C6="",D6=""),"",C6+D6+E5)

 

[Ragdyer]

You're welcome ... And thank you for the feed-back.

 

[Stan Brown]

Mon, 26 Mar 2007 00:52:10 +0100 from Gossipsfrolick

Entries into the Withdrawal column will be made as a negative number. I've
created a formula whereby a new balance is created by adding the values in C
and D to the balance in column E from the previous row. e.g. =(E5+C6+D6).

That seems counter-intuitive. Sooner or later, I bet you dollars to
donuts, your friend will forget to enter a minus sign. Why not have
withdrawals as positive (as they would be written in a checkbook) and
use
=E5-C6+D6
(By the way, there was no need for parentheses.)

My problem is this. So far I have data and values inserted in rows 4 to 11
and have copied the formula down the cells in column E. Once I copy it
beyond the rows with information, it continues to show the same value as
that in cell E11. Is there anyway in which these values can be hidden until
they are the result of calculations from each row?

In E6, put
=if(C6+D6=0,"",E5-C6+D6)