Question related to Solver

[Excel]

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 calculate Mortage Amount and Interest Rate with the help of Solver?

Please help..??

Here is a attached file...

[#2]

@Excel 

What should be the target for Solver? If you want to minimize the monthly payment, the obvious solution would be Mortgage Amount = 0.

[#3]

The Target value should be 1100.

So, how to calculate with the help of Solver?

[#4]

@Excel 

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.

[#5]

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..???

[#6 · Accepted solution]

@Excel 

See for example https://www.solver.com/solver-tutorial-using-solver 

[#7]

Thank you so much sir:smiling_face_with_smiling_eyes::smiling_face_with_smiling_eyes: