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
Bookmarks