How to replace a repeated balance with a symbol   

I have this formula in a cell G53:    =SUM(G52,-E53,F53). It works fine.
However, it shows the same balance until I input a new entry on the empty 
line. How can I hide ( replace ) the balance with a symbol like -
I am using MS  Office 2007 Excel.
Thanks.
-- 
Joe T

date: Wed, 15 Oct 2008 16:56:10 -0700   author:   Joe T

RE: How to replace a repeated balance with a symbol   

Hi Joe
try to use this formula =if(E53=0,"-",sum(G52,-E53,F53)


"Joe T" wrote:

> I have this formula in a cell G53:    =SUM(G52,-E53,F53). It works fine.
> However, it shows the same balance until I input a new entry on the empty 
> line. How can I hide ( replace ) the balance with a symbol like -
> I am using MS  Office 2007 Excel.
> Thanks.
> -- 
> Joe T

date: Wed, 15 Oct 2008 18:34:01 -0700   author:   RaulDR