Returns the highest 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.  

 

Max is not compatible for with numeric series.  To find the highest or largest value in an entire or partial segment of numbers in a series see the function Highest.

Syntax:

value = Max( 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 = Max( 5, 6, 8 )                 ' Returns 8
value = Max( 2 + 1, 5 )                 ' Returns 5

Returns:

Max returns the highest value of the values compared.

 

Links:

Highest, Lowest, Min

See Also:

Mathematical Functions

 


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


Topic ID#: 415

 

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