+ Reply to Thread
Results 1 to 2 of 2

Goal Seek Formula But Not Using Goal Seek

  1. #1
    Registered User
    Join Date
    11-21-2008
    Location
    new hampshire
    Posts
    16

    Goal Seek Formula But Not Using Goal Seek

    Hi,

    I am generally quite good in excel using VBA and other complex formulas, but this one simply has me baffled.

    I have a file in which I want to come up with a formula that will do the following.

    I have a price in column A, an FX rate in Column B, an uplift factor in Column C, and a market factor in column D. Price B is calculated using all of these factors, so the formula in F2 would look like =A2*B2*C2*D2 (Price A * FX * Uplift * Market).

    The tricky part that I am trying to figure out is, how do you determine what the Market factor is if you want to change Price A, but keep Price B static? I do not want to use goal seek because my audience is not educated in excel nor do I want to use VBA.

    I am attaching a file for reference. Any help is very much appreciated.
    Attached Files Attached Files

  2. #2
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2010, 2019
    Posts
    40,689

    Re: Goal Seek Formula But Not Using Goal Seek

    b = a * fx * ul * mf

    mf = b / (a * fx * ul)
    Entia non sunt multiplicanda sine necessitate

+ Reply to Thread

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