MS_Xsmell
Board Regular
- Joined
- Jan 27, 2007
- Messages
- 76
- Office Version
- 365
- Platform
- Windows
I am trying to use the Goal Seek function in a real estate cash flow model to solve the initial acquisition price to an amount required to achieve a target internal rate of return (IRR). The model I am using requires iterative calculations.
Goal seek will not work. It searches for the answer, varying from large negative to large positive numbers and eventually fails. I tried playing with the # of iterations and max change a bit, but couldn't seem to get it to work.
Solver however will find the correct answer without failing.
What's the difference between the two functions? Is there any way to get Goalseek to act like Solver so I can throw it into VBA or am I stuck with trying to figure out Solver?
Since I am only using variable, is it a difference in the default # iterations or Maximum Change?
Thanks.
Goal seek will not work. It searches for the answer, varying from large negative to large positive numbers and eventually fails. I tried playing with the # of iterations and max change a bit, but couldn't seem to get it to work.
Solver however will find the correct answer without failing.
What's the difference between the two functions? Is there any way to get Goalseek to act like Solver so I can throw it into VBA or am I stuck with trying to figure out Solver?
Since I am only using variable, is it a difference in the default # iterations or Maximum Change?
Thanks.