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