Results 1 to 7 of 7

Target Percentage problem

Threaded View

  1. #1
    Registered User
    Join Date
    07-16-2007
    Location
    San Francisco, CA
    MS-Off Ver
    2010
    Posts
    93

    Target Percentage problem

    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
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1