rincewind2019
New Member
- Joined
- Jan 29, 2019
- Messages
- 23
a | b | c | d | e | f | g | h | i | j | k |
income | expend | bank | ||||||||
Date | Description | Rec | Income | Vouch | expend | CHQ No | Deposits | Withdrawal | balance | Cash |
1/1 | B Forward | 100.00 | 10.00 | |||||||
1/1 | Test 1 | 1 | 10.00 | 1 | 100.00 | 20..00 | ||||
2/1 | Test 2 | 1 | 20.00 | 1 | 20.00 | 80 | 0.00 | |||
<tbody>
</tbody>
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.