Forum Discussion
Solved
Question related to Solver
Hello Everyone, As we calculate the Goal Seekcommand (What If analysis) Or Data Table(What If analysis)command, So How to calculate more than input value with the help of Solver? I want to c...
See for example https://www.solver.com/solver-tutorial-using-solver
What should be the target for Solver? If you want to minimize the monthly payment, the obvious solution would be Mortgage Amount = 0.
The Target value should be 1100.
So, how to calculate with the help of Solver?
That is a meaningless question. There is an infinite number of combinations of Mortgage Amount and Interest that will result in a Payment of $1,100.
For example:
amount = $100,000 and interest = 12.63%
amount = $200,000 and interest = 4.40%
amount = $300,000 and interest = 0.77%
etc.
- Actually sir, only i want to know that how to solve more than one input value with the help of Solver.
Can you please explain with any example with the help of Screenshots or Excel Files?
Please..???
