PlsHelp me.
1 A B C D E
2 DATE NAME EXPENSE
3 1-Mar Sara 50 20000 13874
4 2-Mar John 7
5 3-Mar Sara 35
6 4-Mar Sara 47
7 5-Mar Sara 51
8 6-Mar John
9 7-Mar Sara
10 8-Mar John
11 9-Mar John
A= Date
B=Name
C=Expense
D3=20000(CASH IN JOHN’S HAND)
E3=13874(CASH IN SARA’S HAND)
____________________________
CONDITION I
if B3=”Sara”,E3-C3 and the output in the E3. That means Sara’s Expense Should subtract from Sara’s Cash Balanace
____________________________
CONDITION II
IF B3=”John”,D3-C3 and the output in the D3.That means John’s Expense should subtract from John’s Cash Balance
_______________________________
Then hv to check next row B4,B5,B6 ?..Every step John’s and Sara’s Cash Balance need to change