See.

Returns the largest value in a set of values.

grammar

Maximum value (number 1, number 2, ...)

The number 1, the number 2, ... is 1 to 30 numerical parameters used to calculate the maximum value.

explain

You can specify parameters as numbers, blank cells, logical values, or text expressions of numbers. If the parameter is an incorrect value or text that cannot be converted into numbers, an error will be generated.

If the parameter is an array or a reference, only the numbers in the array or reference are calculated. Blank cells, logical values or text in an array or reference are ignored. If logical values and text cannot be ignored, use the function MAXA.

If the parameter does not contain a number, the function MAX returns 0 (zero).

example

It may be easier to understand if you copy the example into a blank worksheet.

operational approach

Create a blank workbook or worksheet.

Please select an example in the help topic. Do not select row or column headings.

Select an example from the help.

Press ctrl+C.

In the worksheet, select cell A 1, and then press ctrl+v.

To switch between viewing results and viewing formulas that return results, press Ctrl+ ` (accent), or on the Tools menu, point to Formula Auditing, and then click Formula Auditing Mode.

1

2

three

four

five

six

A

data

10

seven

nine

27

2

Formula Description (Result)

=MAX(A2:A6) The maximum value (27) in the above set of numbers.

= Max (A2: A6,30) is the maximum value (30) in a set of numbers greater than or equal to 30.