SOLVER.GET

Macro Sheets Only

Returns information about current settings for Solver. The settings are specified in the Solver Parameters and Solver Options dialog boxes.

If this function is not available, you must install the Solver add-in macro.

Syntax

SOLVER.GET(type_num, sheet_name)

Type_num is a number specifying the type of information you want.

The following settings are specified in the Solver Parameters dialog box.

Type_Num Returns

1

The reference in the Set Cell box, or the #N/A error value if Solver has not been used on the active sheet

2

A number corresponding to the Equal To option
1 = Max
2 = Min
3 = Value of

3

The value in the Value Of box

4

The reference (as a multiple reference if necessary) in the By Changing Cells box

5

The number of constraints

6

An array of the left sides of the constraints in the form of text

7

An array of numbers corresponding to the relationships between the left and right sides of the constraints:
1 = <=
2 = =
3 = >=
4 = int

8

An array of the right sides of the constraints in the form of text


The following settings are specified in the Solver Options dialog box:

Type_Num Returns

9

The maximum calculation time

10

The maximum number of iterations

11

The precision

12

The integer tolerance value

13

TRUE if the Assume Linear Model check box is selected; FALSE otherwise

14

TRUE if the Show Iteration Results check box is selected; FALSE otherwise

15

TRUE if the Use Automatic Scaling check box is selected; FALSE otherwise

16

A number corresponding to the type of estimates:
1 = Tangent
2 = Quadratic

17

A number corresponding to the type of derivatives:
1 = Forward
2 = Central

18

A number corresponding to the type of search:
1 = Quasi-Newton
2 = Conjugate Gradient


Sheet_name is the name of a sheet that contains the scenario for which you want information. If sheet_name is omitted, it is assumed to be the active sheet.

Related Functions

List of Information Functions