+ Reply to Thread
Results 1 to 4 of 4

Goalseek on a sumproduct

  1. #1
    Registered User
    Join Date
    01-29-2019
    Location
    Los Angeles, CA
    MS-Off Ver
    Microsoft Office Professional Plus 2016
    Posts
    2

    Goalseek on a sumproduct

    Hi,

    I've attached the Excel worksheet that describes the problem I'm having.

    I'm trying to goalseek a sumproduct formula based on an input. In the attached Excel, it looks like:

    Goalseek.png

    Except when I do this, goal seek gives me the wrong answer. For example, in the first iteration it recommends $505, which is nowhere near the correct answer of ~$593.

    I would appreciate any help with this. Thanks!

    Thank you,
    Lakshay
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    01-29-2019
    Location
    HK
    MS-Off Ver
    10
    Posts
    2

    Re: Goalseek on a sumproduct

    Just a suggestion but your calculation options may not be setup to do the iteration you want. Have a look at calculation options {file->options->formulas in my version}.
    Otherwise it looks like it should work fine and reach 593.24

  3. #3
    Registered User
    Join Date
    01-29-2019
    Location
    Los Angeles, CA
    MS-Off Ver
    Microsoft Office Professional Plus 2016
    Posts
    2

    Re: Goalseek on a sumproduct

    Thank you! What calculation options are you using?

  4. #4
    Registered User
    Join Date
    01-29-2019
    Location
    HK
    MS-Off Ver
    10
    Posts
    2

    Re: Goalseek on a sumproduct

    I left it at Max It.100 and Max change 0.001. It works with iterative calculation on or off and on both manual and automatic calculation.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. GoalSeek VBA freezing up
    By 95marine in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 04-26-2017, 06:40 PM
  2. [SOLVED] VBA to goalseek across column
    By hassanm in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 09-08-2015, 10:43 AM
  3. Goalseek in VBA - Is it possible to see how many iterations were used?
    By Belisartih in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-12-2014, 04:12 PM
  4. Similar to Goalseek
    By pizzle523 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 12-30-2012, 11:18 AM
  5. GoalSeek & Index + GUI
    By defy in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-13-2012, 07:23 PM
  6. Problems in Goalseek
    By elizi in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-26-2007, 06:38 AM
  7. [SOLVED] GoalSeek in VBA
    By [email protected] in forum Excel General
    Replies: 1
    Last Post: 07-20-2006, 12:20 AM

Tags for this Thread

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