I am trying to create a very nuanced budget in Excel. I have a lot of rules about budgeting and thought it would be easier to create a spreadsheet. When a certain line item exceeds budget it is to borrow from another specific line item. Once the 1st line item=0 then it is to stop borrowing. All I know how to do is =IF(n4<0,n4-j9) But if J9 is greater than the amount N4 is negative, how do I get it to stop borrowing funds?
Okay just to try and help explain... Say n4 is positive, then no borrowing from J9 should happen; however, if N4 is say negative 1000, and j9 has $500, then I want N4 to borrow it all. If N4 were negative 1000 and J9 had $2000, then I'd only want it to borrow $1000 and also, later when N4 is positive I'd like to have N4 return the funds to J9 lol. I'm wondering if I can use hidden cells to perform some of the functions or if there is something like nested "IF" functions that would do the trick.
Do you understand what I'm trying to do now?
