Excel - IF Function Problem - Expert Solution

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
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
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.

Get instant expert help with Excel and Google Sheets

Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Your privacy is guaranteed. Your session will not be used for blog unless you give us persmission.

Click here to get your free Excelchat help session

Subscribe to Excelchat.co
Trusted by people who work at
Amazon.com, Inc
Facebook, Inc
Accenture PLC
Siemens AG
The Allstate Corporation
United Parcel Service
Dell Inc