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

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

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

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

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