Contents - Index


MINLOOKUP

 

MINLOOKUP returns the minimum of all or selected cells in a specified column of the Lookup table  or Lookup file on disk The format of this function is:

 

MINLOOKUP('TableName', 'ColumnName')

 

or

 

MINLOOKUP('TableName', 'ColumnName', RowStart, RowStop)

 

'TableName' is a string constant or string variable that contains the name of the Lookup table or Lookup disk file.  The name of the Lookup table is shown on its tab at the top of the table.

 

'ColumnName' is a integer value, string constant or string variable the identifies the column.  If an integer value is provided, it is taken to be the column number in the Lookup table.  If a string constant is provided, it is assumed to be the name of the variable for the column in the Lookup table. The single quotes that normally identify a string constant are not required.  If a string variable is provided, it must contain the name of one of the variables in the Lookup table.

 

RowStart and RowStop are integers or EES variables specifying the starting and stopping rows for which the minimum will be found.  These parameters are optional. 

 

 

See also:  AVGPARAMETRIC

                AVGLOOKUP

 STDDEVLOOKUP

                 SUMLOOKUP

                 SUMPARAMETRIC

                 TABLEVALUE                

                MINPARAMETRIC

                 MAXPARAMETRIC

                 MAXLOOKUP

 Mathematical Functions