judgedredd
New Member
- Joined
- Dec 13, 2015
- Messages
- 27
I haven't seen this exact question answered so would like some help here. It is related to a bank account running total on an Excel Spreadsheet.
I have 3 columns: Credit, Debit and Total
I have tried this formula:
=IF(OR(ISBLANK(B3),ISBLANK(C3)),"0.00",D2+B3-C3) for the 'Total' cell (column D in my sheet, column A being the date). But this does not work and brings up 0.00 in the 'Total' cell.
Can anyone see where the formula is wrong?
I have 3 columns: Credit, Debit and Total
I have tried this formula:
=IF(OR(ISBLANK(B3),ISBLANK(C3)),"0.00",D2+B3-C3) for the 'Total' cell (column D in my sheet, column A being the date). But this does not work and brings up 0.00 in the 'Total' cell.
Can anyone see where the formula is wrong?
Last edited: