ExcelBanter - How to replace a repeated balance with a symbol

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - How to replace a repeated balance with a symbol (https://www.excelbanter.com/excel-discussion-misc-queries/206511-how-replace-repeated-balance-symbol.html)

Joe T

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

RaulDR

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

All times are GMT +1. The time now is 06:31 AM.