+ 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)

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