﻿ Min

# Min Function

Returns the lowest value in a list of values.  List of values can be any number of arguments that create a value, or a list of values.  All values must be separated by a comma.

Min is not compatible for with numeric series.  To find the lowest or smallest value in an entire or partial segment of numbers in a series see the function Lowest.

Syntax:

value = Min( expression1, expression2, expression3, ... )

Parameter:

Description:

expression1

Any numeric expression

expression2

Any numeric expression

expression3

Any numeric expression

...

Additional numeric expressions, if they are needed.

Example:

'  Find the Highest value of the expression

'  values included within the parentheses

value = Min( 5, 6, 8 )                 ' Returns 5
value = Min( 2 + 1, 5 )               ' Returns 3

'  Min or Max can be used in place of an IF loop in certain cases.

IF ( var1 <= var2 ) THEN
var3 = var1
ELSE
var3 = var2
ENDIF

'  You could just use this:
var3 = Min(var1, var2)

Returns:

Lowest returns the lowest value of the values compared.