Forum Discussion
Creating a finance calculator
Hi all, I work in the finance industry and I want to create a calculator to assist in working how much brokerage / commission is earnt on each transaction. The commission we earn is based on a pe...
I think that Excel's Goal Seek feature might interest you. Go to Data tab, What-if Analysis on the right, and then Goal Seek. You can play with it to perform simple "optimization" problems.
There is also the Solver Add-in, which you can include to your Excel if you want to perform it in a more sophisticated way.
Is that what you are looking for?
MAngosto Thanks for the sugesstion