get Cell to not display ( $ - )
 

hi, i have cells that are formatted for accounting and the cell formula
contains the SUM feature, when the cells are empty and waiting for a value,
they display ($ -) and so i have those symblos everywhere and would like the
cell just to be blank and then show up with the dollar sign when a value
appears in it.

Any ideas?
thanks

get Cell to not display ( $ - )
 

Try this. There might be an easier one, but this is what I use.

S

14 5
15 5
=IF(SUM(S14:S18)=0,"",(SUM(S14:S18)))
16 5
17 5
18 5


--
Thanks!


"Morgan" wrote:

hi, i have cells that are formatted for accounting and the cell formula
contains the SUM feature, when the cells are empty and waiting for a value,
they display ($ -) and so i have those symblos everywhere and would like the
cell just to be blank and then show up with the dollar sign when a value
appears in it.

Any ideas?
thanks

get Cell to not display ( $ - )
 

thanks it works
--
thanks


"mahlandj" wrote:

Try this. There might be an easier one, but this is what I use.

S

14 5
15 5
=IF(SUM(S14:S18)=0,"",(SUM(S14:S18)))
16 5
17 5
18 5


--
Thanks!


"Morgan" wrote:

hi, i have cells that are formatted for accounting and the cell formula
contains the SUM feature, when the cells are empty and waiting for a value,
they display ($ -) and so i have those symblos everywhere and would like the
cell just to be blank and then show up with the dollar sign when a value
appears in it.

Any ideas?
thanks

get Cell to not display ( $ - )
 

"mahlandj" wrote:
Try this. [....]
=IF(SUM(S14:S18)=0,"",(SUM(S14:S18)))

"Morgan" wrote:
thanks it works

It does?! If so, fine. But I would think you want "$ -" when the sum is
exactly zero. In that case, try:

=IF(COUNT(S14:S18)=0, "", SUM(S14:S18))


----- original message -----

"Morgan" wrote:

thanks it works
--
thanks


"mahlandj" wrote:

Try this. There might be an easier one, but this is what I use.

S

14 5
15 5
=IF(SUM(S14:S18)=0,"",(SUM(S14:S18)))
16 5
17 5
18 5


--
Thanks!


"Morgan" wrote:

hi, i have cells that are formatted for accounting and the cell formula
contains the SUM feature, when the cells are empty and waiting for a value,
they display ($ -) and so i have those symblos everywhere and would like the
cell just to be blank and then show up with the dollar sign when a value
appears in it.

Any ideas?
thanks