Question description:
This user has given permission to use the problem statement for this
blog.
I need to help on IF formulas to calculate year to year (deducted, adding, combining, etc) automatically from one year to the next.
Solved by E. H. in 59 mins
This is the chat thread from the real Excelchat help session. It contains no private user
information.
Excelchat Expert
04/05/2018 - 06:19
Hi
User
04/05/2018 - 06:19
Hi there
Excelchat Expert
04/05/2018 - 06:19
Welcome to Got it Pro
User
04/05/2018 - 06:20
I was disconnected from the last person .. was that you? On banking and borrowing 200?
Excelchat Expert
04/05/2018 - 06:20
Can you explain your requirement so that i can help you better
Excelchat Expert
04/05/2018 - 06:20
I think not but i think i did one question earlier on banking and borrowing
Excelchat Expert
04/05/2018 - 06:21
I think i help you with that value in C2
Excelchat Expert
04/05/2018 - 06:21
which was 200
Excelchat Expert
04/05/2018 - 06:21
Do you remember?
Excelchat Expert
04/05/2018 - 06:22
Please tell
User
04/05/2018 - 06:24
YES!!!
User
04/05/2018 - 06:24
Okay so I need more help :(
Excelchat Expert
04/05/2018 - 06:24
Yes tell me
Excelchat Expert
04/05/2018 - 06:24
Do you have the last formula that i made for you
Excelchat Expert
04/05/2018 - 06:24
?
User
04/05/2018 - 06:25
Okay I think I got all the formulas in there. Some may be incorrect so let me explain from the top
User
04/05/2018 - 06:26
C2 is the amount that is deposited each year and should be reflected in the Bankable column for each year, however, 2018 and 2019+ will be different formulas. Let me explain
User
04/05/2018 - 06:28
In 2018 under Banked I should have started with 200 because that's the amount I banked from 2017 (not shown in spreadsheet). Bankable is being pulled from C2 which is the amount I can bank to the following year. In the Remaining column, it should be the Banked plus bankable. In the Used amount it should take from the Banked amount first and then the bankable amount.
User
04/05/2018 - 06:29
For the Borrowed in 2018 ... If I enter an amount in G5 that will then effect my bankable in 2019 and so forth. So if I put 50 in the borrowed in 2018, my remaining (I6) should then say 450 but my bankable in K6 should be 150 because I borrowed from that year for the previous year.
User
04/05/2018 - 06:34
Does that make sense?
User
04/05/2018 - 06:36
Are you still there?
User
04/05/2018 - 06:45
Can't help me?
This is the output file from the real Excelchat help session:
This is an example of the expert help you can get. It contains no private user
information.