Results 1 to 2 of 2

Goal Seek Formula But Not Using Goal Seek

Threaded View

cady923 Goal Seek Formula But Not... 08-05-2011, 03:07 PM
shg Re: Goal Seek Formula But Not... 08-05-2011, 03:53 PM
  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

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