MAX
Returns the maximum of numers in a range.
Syntax
MAX(range; orientation)
range - a range of values - Value type: range
orientation - the orientation of the maximum calculation - Value type: constant (optional, all as default). Possible values are:
all - the maximum of the whole range is returned as a single number
horizontal - the maximum calculation is performed horizontally (row-wise) and returned as a column of numbers“
vertical - the maximum calculation is performed vertically (column-wise) and returned as a row of numbers
Remarks
Empty cells or cells which cannot be converted to numbers are ignored in the maximum calculation.
