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