+ Reply to Thread
Results 1 to 2 of 2

Using Goal Seek to determine value within Range

  1. #1
    Forum Contributor
    Join Date
    11-14-2007
    Posts
    111

    Using Goal Seek to determine value within Range

    Here is my situation (example) in A2 I want to put an amount to transfer. In A3, I have a balance of -$1,406,687.79 In increments of $100,000, i want to use Goal Seek or Scenario Manager or a formula if it is possible, to generate the A2 number that leaves between -$100,000 and -$80,000 in A3.

    So, for this example, I would like to be able to generate in A2: $1,300,000 (leaving -$106,687.79 in A3).

    Thanks

  2. #2
    Forum Contributor
    Join Date
    11-14-2007
    Posts
    111
    I'm sorry, i want to leave between -&100,000 and -$180,000 (not -80,000)

    Thanks

+ 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