Hi All,
I have a percentage problem that I do not know how to solve, to achieve the total cost, I would perform the calculations as follows:
[CODE]amount rate * percentage = amt 1
fee1 : amt 1 * (prior fee1/prior amt 1) = fee1
fee2 : amt 1 * .0058 = fee 2
fee3 : percentage * 36 = fee 3
total amount = amt 1 + fee1+fee2+fee3
[code]
With being explain, my goal is to input the total amount and have it calculate what the percent should be to achieve the target amount,
I have included a spread sheet.
Any assistance would be appreciated, I have thought of using the analyst tool pack:"what if" of Solver but am unfamiliar with this.
Thanks James
Bookmarks