Hi, I'm having some weird behavior from both Solver and Goal Seek and hoping someone on here can help. Basically I have a series of columns with cash flow rows for Income and Expenditure, over time. The Expenditure rows include a tax expense which it calculates by looking at the Income. The cell that I am solving for is Net Income which simply equals Income - Expenditure. I have a macro which checks across the columns that Net Income is > 0. If Net Income is < 0 it will run a Goal Seek to put Income in a certain cell so that the end result is Net Income = 0.
That said, the problem with the sheet is that the Goal Seek function works perfectly fine on most cells but will, seemingly at random, leave some cells unsolved. I attempted to use Solver function in the same way and I'm getting the same result. Solver is not ideal because it seems to be a lot slower than Goal Seek. Even when I isolate the cell and manually run Goal Seek or Solver on it, it still can't find a solution. Meanwhile, I can iteratively input my own guesses and eventually arrive at a solution. Presumably if I can do that then either Goal Seek or Solver should be able to do the same right?
That said, the problem with the sheet is that the Goal Seek function works perfectly fine on most cells but will, seemingly at random, leave some cells unsolved. I attempted to use Solver function in the same way and I'm getting the same result. Solver is not ideal because it seems to be a lot slower than Goal Seek. Even when I isolate the cell and manually run Goal Seek or Solver on it, it still can't find a solution. Meanwhile, I can iteratively input my own guesses and eventually arrive at a solution. Presumably if I can do that then either Goal Seek or Solver should be able to do the same right?
