Max

Syntax

Max(Values1,...)

Values1, Values2, …, ValuesN. The range of cells, the maximum of which you want to find.

NOTE. Either value itself or address of the cell (cell range) containing this value can be specified as the parameter.

It returns the maximum number in the cell array.

If the Check References to Empty Cells checkbox is not selected in report formula settings, and:

A cell range, for which the maximum value should be calculated, entirely consists of empty values, the function returns empty value.
A cell range, for which the maximum value should be calculated, contains several empty values, the function is calculated without taking into account empty values.

If the Check References to Empty Cells checkbox is selected, empty values in cells are considered as zero ones.

Formula	Result	Description
=Max(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.
=Max(10,5,28,13)	28	The maximum number in the specified array.