Forum Discussion
Can you automate goal seek in excel
Hi ecveryone, is it possible to automate goal seek?
Please check your workbook. Your formulas add H7 to an amount and subtract H7 from an amount, but H7 is supposed to be a percentage. I suspect that is not what you intended.
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
Here you go. I have corrected the formulas.
- Thanks Hans, workes perfectly.
Cheers