False 6 Solver False 0 0 dialog False vertical 12 False end _Help True True True True False True 0 True _Reset All True True True True True True 1 O_ptions... True True True True Opens the Solver Options dialog. False True 2 _Solve True True True True True True False True 3 _Close True True True True False True 4 False True end 0 True False True True vertical 12 True False True 6 12 True False _Target cell True 0 0 0 True False Optimize result to True max 0 0 0 1 3 True False _By changing cells True 0 0 4 Minim_um True True False True True max Enter the cell range that can be changed. 1 2 _Maximum True True False True True True Enter the cell range that can be changed. 1 1 True False True 6 True True True True 32 True Enter the cell range that can be changed. False True 0 True True True False True 1 1 4 True False True 6 True True True 32 True Enter or click the cell reference of the target cell. This field takes the address of the cell whose value is to be optimized. False True 0 True True True False True 1 1 0 True False True 12 _Value of True True False True True max Enter the cell range that can be changed. False True 0 True False True 6 True True True True True Enter the cell range that can be changed. False True 0 True True True False True 1 False True 1 1 3 False True 0 True False True True 0 none True True 12 6 True True never always in True False True True False True True False start True 3 6 6 True False _Cell reference True 0 0 0 2 True False _Operator True 0 2 0 True False 6 V_alue True 0 3 0 3 True True True True 20 True Cell reference 0 1 True True True True 20 True Cell reference 0 2 True True True True 20 True Cell reference 0 3 True True True True 20 True Cell reference 0 4 True True True 1 1 True True True 1 2 True True True 1 3 True True True 1 4 True False <= = => Integer Binary Operator 2 1 True False <= = => Integer Binary Operator 2 2 True False <= = => Integer Binary Operator 2 3 True False <= = => Integer Binary Operator 2 4 True True 6 True True 15 True Value 3 1 True True 6 True True 15 True Value 3 2 True True 6 True True 15 True Value 3 3 True True 6 True True 15 True Value 3 4 True True True 4 1 True True True 4 2 True True True 4 3 True True True 4 4 True True True Remove 5 2 True True True Remove 5 1 True True True Remove 5 3 True True True Remove 5 4 0 0 True False Limiting Conditions False True 1 False True 1 help options ok close Opens the Solver dialog. A solver allows you to solve mathematical problems with multiple unknown variables and a set of constraints on the variables by goal-seeking methods. vertical