Forum Discussion
robwill100
May 07, 2024Brass Contributor
Can you automate goal seek in excel
Hi ecveryone, is it possible to automate goal seek?
HansVogelaar
May 09, 2024MVP
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.
robwill100
May 10, 2024Brass Contributor
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
- HansVogelaarMay 10, 2024MVP
Here you go. I have corrected the formulas.
- robwill100May 13, 2024Brass ContributorThanks Hans, workes perfectly.
Cheers