PsiDecTable

PsiDecTable(table_range, [output], [ret_header], input_val1, inputval2)

This function defines a decision table over the constant range, table_range, for the specified inputs.

table_range (Required) – This is the cell range of the decision table in the Excel worksheet.

output_names (Optional) – Use this argument to control what is returned in the result.

return_header (Optional) – Use this argument to insert a header at the beginning of each column of results. 

input_valX (Required) – Analytic Solver supports anywhere from 1 to 253 input variables in the decision table.  

Example:

=PsiDecTable(G7:K16, "holidays", TRUE, age, service) where

G7:K16 is the location of the decision table on the Excel worksheet,

"holidays" (optional) to ensure that the returned results only include the specified output and

TRUE to add a header to the result, 

age and service are the two input variables.

For more information on this Psi function, see the Frontline Solvers User Guide.