Can you automate goal seek in excel

JoeUser2004 

Thanks Joe, I have corrected the link.

Harun24HR

Hi Harun, thank you for your reply. I have explained below what I am trying to achieve and I would appreciate your assistance in being able to write the required formula. I have attached the spreadsheet I am working on.

The overall objective is to calculate the brokerage percentage in cell H5.

To achieve this I am currently using the goal seek function.

Prior to using the goal seek function I first have to under the heading Customer:

1. Input into cell D3 the amount of the loan.
2. Input the term of the loan in years in cell D5
3. Input the repayment amount per month into cell D7.

Once I have done that the annual interest rate for loan is shown in cell D4 where I have used the RATE formula.

Once I have completed that I then need to under the heading financier:

1. Input the new interest in cell H11.
2. At this point I use the goal seek function whereby I choose cell H12 followed by inputting into the “to Value” section the monthly pmt from cell D7. ($890 in this example) I then in the  “by changing cell” choose cell H5. (brokerage percentage). The result of the goal seek then calculates the brokerage percentage.

If its possible to do this via a formula rather than using goal seek I would really appreciate your help.

Cheers

Rob