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.


= MAX(number1, [number2], …)


– Number 1 is required;

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


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?

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