-SCS Parameter Analyzer Reference Manual Section 6:
4200A-901-01 Rev. C / February 2017 6-285
MAX Calc worksheet function
This command returns the largest value in the specified list of numbers.
Usage
MAX(Value_list)
Value_list
A list of as many as 30 numbers separated by commas
Details
The Value_list can contain numbers, logical values, text representations of numbers, or a
reference to a range containing those values.
Error values or text that cannot be translated into numbers return errors.
If a range reference is included in the list, text, logical expression and empty cells in the range are
ignored.
If there are no numbers in the list, 0 is returned.
Example
=MAX(50, 100, 150, 500, 200)
=MAX(A1:F12)
Returns 500.0000E+0.
Returns the largest value in this range.
Also see
AVERAGE (on page 6-277)
MIN (on page 6-286)