Model 4200A-SCS Parameter Analyzer Reference Manual
Section 6: Clarius
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)
