Goal seek w/ multiple variables

Hi,

I have quite the challenge for you guys:

Description:
problem.png
Workbook:
Sparing.xlsx


Hopefully there's someone out there that can help!

-mads,

Welcome to the forum!
Here's some advice, taken straight from the Forum Rules in the section labelled "Want to get your question answered quickly?":
Post a WORKBOOK. Nobody wants to type data from a picture or paste text from your post into a spreadsheet as a prelude to helping. To attach a file, push the button with the paperclip (or scroll down to the Manage Attachments button), browse to the required file, and then push the Upload button.

-mads,

The actual workbook has a second set of tables that the picture you provided doesn't show. Which set of tables are we supposed to use? The left-hand three, or the right-hand three (that all end with "inkl. skatt")?

In a cell, say A1, enter =P9+P19+P29

Data > Solver, Set Cell A1 to Max by changing D5:D7, subject to the constraints

D5:D7 >=0
D9 = 200000

Before:

      -------A------- ----B----- ------C------- -------D------- ---E--- -------F-------
  1    kr 620,112.00   SPARING                                                         
  2                                                                                    
  3                                                                                    
  4                     KONTO       INNSKUDD      MÅLSETNING    PROSENT   GJENSTÅENDE  
  5                   Aksjer       kr 9,000.00    kr 70,000.00      13%   kr 61,000.00 
  6                   Fond              kr -      kr 70,000.00       0%   kr 70,000.00 
  7                   Sparekonto   kr 8,200.00    kr 20,000.00      41%   kr 11,800.00 
  8                   BSU          kr 5,000.00    kr 40,000.00      13%   kr 35,000.00 
  9                   Totalt      kr 22,200.00   kr 200,000.00      11%  kr 177,800.00

After:

      -------A------- ----B----- ------C------- -------D------- ---E--- -------F-------
  1    kr 620,892.00   SPARING                                                         
  2                                                                                    
  3                                                                                    
  4                     KONTO       INNSKUDD      MÅLSETNING    PROSENT   GJENSTÅENDE  
  5                   Aksjer       kr 9,000.00          kr -    #DIV/0!   -kr 9,000.00 
  6                   Fond              kr -     kr 160,000.00       0%  kr 160,000.00 
  7                   Sparekonto   kr 8,200.00          kr -    #DIV/0!   -kr 8,200.00 
  8                   BSU          kr 5,000.00    kr 40,000.00      13%   kr 35,000.00 
  9                   Totalt      kr 22,200.00   kr 200,000.00      11%  kr 177,800.00

Thanks, that was it!