I have spreadsheet with a "total" column containing the formulas " previous total - debit + credit"
Can someone tell me how to stop the whole column being filled with the last total entry, when there no entries in the other "debit" or "credit" cells, please.