How to Use MAX Function

In statistics, the maximum value in a dataset is the value of the greatest observation of a sample. You can use the MAX function to find the largest value from a set of data values.

Formula:

= MAX(number1, [number2], …)

Explanations:

– Number 1 is required;

– [number2], …: numbers other than the first are optional.

Cautions:

The MAX function will count numbers, arrays or references that contain numbers, while empty cells or cells with text values will be ignored.

Example: What is the maximum income in column C?

=MAX(C2:C6)
The maximum income is $100,835.

Note: When cells contain error values or text that cannot be translated into numbers, the MAX function will return errors.

Leave a Reply