Maxa

Syntax

Maxa(Value1,...)

Value1, Value2, …, ValueN. Range of cells, the maximum of which you want to find.

It returns the maximum value in the cell array that contains not only numeric values.

Parameter values may include numbers, empty cells, logical values, text, cell references, formulas. The number of values may be from 1 to 255.

The True value is interpreted as -1, text values, and the False value is interpreted as 0.

Only Latin letters are allowed.

Formula	Result	Description
=Maxa(A7:A9, A11, A6)	270	Maximum number in the array stored in the cells A7:A9, A11, A6. The A6 cell contains the 180 number, the A7 cell contains the 2 number, the A8 cell contains the 270 number, the A9 cell contains the 50 number, the A11 cell contains the 100 number.
=Maxa(true, false, 15, 10)	15	Maximum number in the specified array.