Hide blank data
 

I have a simple spreadsheet that lists credits/debits and balance in 3 columns
I want to have a running total in the balance column.
How can I keep the formula for each cell but not show it as say £0.00, until
it is actually populated with valid data
Currently the formula is =SUM(F7,-D8,E8)
D column is debits, E column is credits, F column is balance

Any suggestions would be much appreciated.
Thanks
Mat

Hide blank data
 

hi
try this...
=IF(SUM(F7,-D8,E8)=0,"",SUM(F7,-D8,E8))

regards
FST1

"OceanMat" wrote:

I have a simple spreadsheet that lists credits/debits and balance in 3 columns
I want to have a running total in the balance column.
How can I keep the formula for each cell but not show it as say £0.00, until
it is actually populated with valid data
Currently the formula is =SUM(F7,-D8,E8)
D column is debits, E column is credits, F column is balance

Any suggestions would be much appreciated.
Thanks
Mat

Hide blank data
 

But presumably there may be valid data which would give a sum of zero?

If the OP doesn't want an answer until data is entered in all 3 input cells,
then perhaps:
=IF(COUNT(F7,-D8,E8)=3,SUM(F7,-D8,E8),"")
--
David Biddulph

"FSt1" wrote in message
...
hi
try this...
=IF(SUM(F7,-D8,E8)=0,"",SUM(F7,-D8,E8))

regards
FST1

"OceanMat" wrote:

I have a simple spreadsheet that lists credits/debits and balance in 3
columns
I want to have a running total in the balance column.
How can I keep the formula for each cell but not show it as say £0.00,
until
it is actually populated with valid data
Currently the formula is =SUM(F7,-D8,E8)
D column is debits, E column is credits, F column is balance

Any suggestions would be much appreciated.
Thanks
Mat

Hide blank data
 

Hi
Thanks for these, but the main thing I need is to show the cell blank if
nothing is entered - the user will enter either a debit or a credit alongwith
the business details and the running total on the right will update - but it
will be a blank cell otherwise (I do not want a whole column of '£0.00'
shown.)
Does this explain it better ?
Thanks
Mat

"David Biddulph" wrote:

But presumably there may be valid data which would give a sum of zero?

If the OP doesn't want an answer until data is entered in all 3 input cells,
then perhaps:
=IF(COUNT(F7,-D8,E8)=3,SUM(F7,-D8,E8),"")
--
David Biddulph

"FSt1" wrote in message
...
hi
try this...
=IF(SUM(F7,-D8,E8)=0,"",SUM(F7,-D8,E8))

regards
FST1

"OceanMat" wrote:

I have a simple spreadsheet that lists credits/debits and balance in 3
columns
I want to have a running total in the balance column.
How can I keep the formula for each cell but not show it as say £0.00,
until
it is actually populated with valid data
Currently the formula is =SUM(F7,-D8,E8)
D column is debits, E column is credits, F column is balance

Any suggestions would be much appreciated.
Thanks
Mat

Hide blank data
 

So in which situation do you want the result blank?

I've already given you the formula which will give a blank result if any of
the 3 input cells is blank.

If you want a blank result only if *all 3* input cells are blank, change my
formula from
=IF(COUNT(F7,-D8,E8)=3,SUM(F7,-D8,E8),"") to
=IF(COUNT(F7,-D8,E8)<0,SUM(F7,-D8,E8),"")
--
David Biddulph

"OceanMat" wrote in message
...
Hi
Thanks for these, but the main thing I need is to show the cell blank if
nothing is entered - the user will enter either a debit or a credit
alongwith
the business details and the running total on the right will update - but
it
will be a blank cell otherwise (I do not want a whole column of '£0.00'
shown.)
Does this explain it better ?
Thanks
Mat

"David Biddulph" wrote:

But presumably there may be valid data which would give a sum of zero?

If the OP doesn't want an answer until data is entered in all 3 input
cells,
then perhaps:
=IF(COUNT(F7,-D8,E8)=3,SUM(F7,-D8,E8),"")
--
David Biddulph

"FSt1" wrote in message
...
hi
try this...
=IF(SUM(F7,-D8,E8)=0,"",SUM(F7,-D8,E8))

regards
FST1

"OceanMat" wrote:

I have a simple spreadsheet that lists credits/debits and balance in 3
columns
I want to have a running total in the balance column.
How can I keep the formula for each cell but not show it as say £0.00,
until
it is actually populated with valid data
Currently the formula is =SUM(F7,-D8,E8)
D column is debits, E column is credits, F column is balance

Any suggestions would be much appreciated.
Thanks
Mat