Forum Discussion
Jennifer Dearth
Jun 21, 2018Copper Contributor
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 tryin...
Matt Mickle
Jun 22, 2018Bronze Contributor
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.