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)


--
Stan Brown, Oak Road Systems, Tompkins County, New York, USA
http://OakRoadSystems.com/