Forum Discussion
Nesting Multiple Functions
I am trying to make a budget spreadsheet to help determine personal expenses vs. savings. I have simple formulas adding income, adding expenses and subtracting expenses from income. Now I am trying to add a row for the balance in my savings account, in case I need to dip into it for some reason or so I can add to it. Here is my problem. In theory, my function below should work. It even estimates the number 66, which is of course correct. But when I press enter to finalize the function, it comes up with zero. This is because, in the example below, the destination of the function is within the function itself (I44). I have tried to come up with a workaround and everything I have tried has come up invalid or the wrong amount.
H32 has fx= SUM(H2:H31)
H34 has fx= SUM(H37:H43)
H35 has fx= IMSUB(H34,H32)
I want the result of my Savings Acct Bal to be, for example, the result in H44 + the result in I35 - the result in H41 = result falls into I44.
Thanks for your help!
1 Reply
It sounds like you're running into a circular reference problem. Is there anyway you could provide a mockup of the example file you are using for this budget spreadsheet. Or perhaps hold down Ctrl + ~ and take a screenshot so the community can see the other formulas you are using and and corresponding precedent or dependent cells? It's hard to test your scenario without more specifics. The test workbook I made doesn't make much sense based on what I'm seeing in your particular screenshot scenario. Then again maybe I'm missing something simple.
In short a before and after. What you are getting now vs. what you expect to see.
