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.

'  Instead of:
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.

 

Links:

Highest, Lowest, Max

See Also:

Mathematical Functions

 


Edit Time: 9/25/2017 09:09:58 AM


Topic ID#: 420

 

Created with Help & Manual 7 and styled with Premium Pack Version 2.80 © by EC Software