Thread: hiding numbers when drag formulas

Hello,
New to Excel.Have put correct formula in ,but when I drag this down the result number in the first row continues to show down all the way.It is a simple formula which adds profit/loss to starting bank.
What is happening is the first recorded total is replicated when I drag the formula down.Is there a way to hide this number in the rows that do not yet have the infromation recorded?

The formula I have put in the H column is =H3+G4,and then dragged this down.It works ok but :
This is what it looks like.After the twenty I have not entered any information as this will come on a wekly basis.Thus column is showing the latest figure all the way down as far as I have dragged the formula.
profit/loss bank
1000
9 1009
10 1019
-20 999
999
999

Hello,
Thans for response.Unfortunately that formula did not prevent the balnces from showing.
The two columns I am working with are G and H .G works out the profit or loss and then H is the updatwed bank balance.
The formula I have been using in column H is =H3+G4 where H3 is the opening bank balance and to this is added any profit from column G.
Now I drag this formula down and column H shows the last calculated balance all the way down.
For example if my opening balance in H 3 is 1000 and G4 is 10 then H4 =1010.Now if there are not any entries in G5 ,G6,G7 the balance of 1010 still shows all the way down.What I want is to not have balance showing when there are as yet no entires.

Originally Posted by plato

Hello,
Thans for response.Unfortunately that formula did not prevent the balnces from showing.
The two columns I am working with are G and H .G works out the profit or loss and then H is the updatwed bank balance.
The formula I have been using in column H is =H3+G4 where H3 is the opening bank balance and to this is added any profit from column G.
Now I drag this formula down and column H shows the last calculated balance all the way down.
For example if my opening balance in H 3 is 1000 and G4 is 10 then H4 =1010.Now if there are not any entries in G5 ,G6,G7 the balance of 1010 still shows all the way down.What I want is to not have balance showing when there are as yet no entires.

In which case try:

=IF(G4=0,"",H3+G4)

Rgds

Hello,
I would like to thank all for your prompt assistance.This is a very efficient forum.I do not know what I did wrong the first time but Old Chippys solution worked perfectly the second time.
Once again thanks everyone.