Can you automate goal seek in excel

HansVogelaar 

Thanks Hans,

Maybe I should have given a little bit more background.

We have a maximum amount of brokerage we can charge depending on the amount being financed. If the brokerage amount exceeds the maximum we have to charge the extra as an origination fee.

Therefore what I am trying to achieve in this example is to workout what the total brokerage is, if it exceeds 4% I want the brokerage amount in cell H6 to show what 4% equals, (in this case $2,117.75) and have the balance displayed as a percentage in cell H7 and the amount displayed in dollars in cell H8.

The same idea would apply for the brackets of amount financed I have listed in the workbook.

I hope this helps