Simple Cash Book. Formula proble in Column K

[rincewind2019]

---

[TABLE="width: 500"]
<tbody>[TR]
[TD]a
[/TD]
[TD]b
[/TD]
[TD]c
[/TD]
[TD]d
[/TD]
[TD]e
[/TD]
[TD]f
[/TD]
[TD]g
[/TD]
[TD]h
[/TD]
[TD]i
[/TD]
[TD]j
[/TD]
[TD]k
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]income
[/TD]
[TD][/TD]
[TD]expend
[/TD]
[TD][/TD]
[TD]bank
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Date
[/TD]
[TD]Description
[/TD]
[TD]Rec
[/TD]
[TD]Income
[/TD]
[TD]Vouch
[/TD]
[TD]expend
[/TD]
[TD]CHQ No
[/TD]
[TD]Deposits
[/TD]
[TD]Withdrawal
[/TD]
[TD]balance
[/TD]
[TD]Cash
[/TD]
[/TR]
[TR]
[TD]1/1
[/TD]
[TD]B Forward
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]100.00
[/TD]
[TD]10.00
[/TD]
[/TR]
[TR]
[TD]1/1
[/TD]
[TD]Test 1
[/TD]
[TD]1
[/TD]
[TD]10.00
[/TD]
[TD]1
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]100.00
[/TD]
[TD]20..00
[/TD]
[/TR]
[TR]
[TD]2/1
[/TD]
[TD]Test 2
[/TD]
[TD][/TD]
[TD][/TD]
[TD]1
[/TD]
[TD]20.00
[/TD]
[TD]1
[/TD]
[TD][/TD]
[TD]20.00
[/TD]
[TD]80
[/TD]
[TD]0.00
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

---

I have put together a simple Cash book. In test 1 the formula =IF(OR(ISBLANK(A4),ISBLANK(B4)),"",D4+K3-F4) works fine to calculate Plus or Minus in the cash column.
My problem is that in test 2, where I have bank transaction I need the cash column in K4 to copy down to K5 while still calculating the change in the bank column I am using the formula =IF(OR(ISBLANK(A5),ISBLANK(B5)),"",D5+K4-F5)

Thanks in advance.

 

[rincewind2019]

That works perfectly, thank you so much.

 

[rincewind2019]

Hi again,

The formula you sent works great, thank you. there is just one more thing.
I also need formula to take into account moving cash to and from the bank column so the only cells filled in would be Date, Description and either deposit or withdrawal depending on if the money as going into or coming out of the cash column.

any ideas?

 

[rincewind2019]

I figured out the formula for row K as =IF(OR(ISBLANK(A10),ISBLANK(B10)),"",IF((H10+I10)=0,D10+K9-F10,K9-H10+I10)) which takes from the cash column and places it in the bank column.
Do you know the formula to do the reverse in the J column, withdrawing cash from the J bank column to place in the K cash column?
The formula in the J column at the moment is =IF(OR(ISBLANK(A10),ISBLANK(B10)), "",H10+J9-I10)