Remaining Balance

[sa.1985]

Dear Sir,

Please find attached sheet.
Query : I want to put formula in E column.

Date Credit Withdrawal Remain. Balance
21/01/18 100 0
22/01/18 200 300 300

IF I WITHDRAWAL ON 22-01-2018 THEN ABOVE BALANCE WILL ZERO in remain. Balance column.

 

[GraH - Guido]

I believe there to be a logical error in your formulas. You make sums of the columns C,D and E and you use these totals in your IF-statement, but then again you try to something cumulative. Point is, I have it hard to understand what you try to accomplish.
Would it make sense to have like a starting balance.
Then Remain balance is starting balance + accumulated credits minus accumulated withdrawals?

 

[vletm]

sa.1985
to E5 =D5-C5
to E6 = E5-C6+D6 and copy down
... F-column 'formulas' shows ... C-column values ... hmm?
C3,D3,E3 ... sums ... hmm?

You wrote: IF I WITHDRAWAL ON 22-01-2018...
... with 300? then E6 will be 0
... but how that would do something with E5?