Hide Info

[Guest]

I am new to excel. I have been creating a spreadsheet to keep track of my
money.
On one sheet called Bill Money I have these column heads
DATE DETAILS IN OUT TOTAL
In the total column i have a formula that takes the previous TOTAL - OUT +
IN = TOTAL. I have copied all the formula down the total column but what
happens is the last total i have is displyed all the way to the last row. Is
there a way that the total can be hiden from the empty rows untill i enter
something on that row.
Cheers
Simon

 

[Jim Rech]

There are two ways to handle this. You can turn off the display of zeros
under Tools, Options, View. Or you can use a formula similar to this:
=IF(SUM(A1:A10)=0,"",SUM(A1:A10))

--
Jim
|I am new to excel. I have been creating a spreadsheet to keep track of my
| money.
| On one sheet called Bill Money I have these column heads
| DATE DETAILS IN OUT TOTAL
| In the total column i have a formula that takes the previous TOTAL - OUT +
| IN = TOTAL. I have copied all the formula down the total column but what
| happens is the last total i have is displyed all the way to the last row.
Is
| there a way that the total can be hiden from the empty rows untill i enter
| something on that row.
| Cheers
| Simon