Question
Thread display: Collapse - |
All Answers
Start or search
Create a new discussion
If you're asking for technical help, please be sure to include all your system info, including operating system, model number, and any other specifics related to the problem. Also please exercise your best judgment when posting in the forums--revealing personal information such as your e-mail address, telephone number, and address is not recommended.
excel formula output in another cell
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