rincewind2019
New Member
- Joined
- Jan 29, 2019
- Messages
- 23
[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.