Max
Calculates the (numerical) maximum out of all of the values in a list of values, ranges and/or lists.
Syntax
Max(param1, param2, ...)
param1 = first parameter in the value set (value, range, or list)
param2 = second parameter in the value set (value, range, or list)
... = nth parameter in the value set (value, range, or list)
Remarks
This function accepts an unlimited number of parameters.
Any non-numerical values are ignored.
See also Min
Examples
Max(1, 2) = 2Max(A1:B3) = the maximum of all of the numerical values in the A1:B3 range