Excel MAX Function and Formula with Examples


How to Use the MAX Function and Formula in Excel

In this tutorial, you'll learn how to use the Excel MAX functionMAX() is a function to get the max value in a set of values.

MAX Syntax

The syntax of the MAX function is as follows:

=MAX(value1, [value2], ...)

Arguments

  • value1: The first argument
  • value2: Optional. The second argument

Remarks

  • You can specify up to 255 arguments.
  • Arguments (value1value2, ...) can either be numbers, arrays, or references that contain numeric values.
  • If the arguments contain no numbers, MAX returns 0.
  • MAX() ignores the text, empty cells, or logical values in the array or reference.

MAX Function Examples

Example 1: Max Value in a Group of Individual Numbers

In this example, let's say you want to get the max value among 10, 30, 20, 20, 80, and 50.
The MAX formula is as follows:

=MAX(10,30,20,20,80,50)

MAX() returns 80, which is the max value among the numbers in the group.

Next, let's see more examples.
The following is the demo list of sales records we're going to use in the examples:

 ABCDEF
1DateItem CodeItem NameQtyUnit PriceAmount
212/4/2019Item0001HP Desktop White 1212002400
312/4/2019Item0002HP Desktop Black 2112401240
412/5/2019Item0003HP Desktop Blue 3311303390
512/5/2019Item0003HP Desktop Blue 3411304520
612/5/2019Item0002HP Desktop Black 2512406200
712/6/2019Item0001HP Desktop White 1111201120
812/7/2019Item0001HP Desktop White 1711508050
912/9/2019Item0003HP Desktop Blue 3311003300
1012/9/2019Item0002HP Desktop Black 2812009600
1112/10/2019Item0003HP Desktop Blue 3210002000

Example 2: Find the Max Value in a Single Range of Cells

In this example, let's say you want to get the largest amount in column amount from cell F2 through F11.
The MAX formula is as follows:

=MAX(F2:F11)

MAX returns 9600, which is the largest value in the range F2:F11.

Example 3: Find the Max Value in Multiple Ranges of Cells

The following illustrates an example of finding the max value in multiple ranges of cells:

=MAX(320,F2:F4,F6:F8,F10:F11, 10000)

Here, the MAX formula has five arguments.

MAX returns 10000, which is the max value among them.

Example 4: MAX() Ignores Text, Empty Cells, or Logical Values

MAX returns 0 if the arguments contain no numbers.
Let's take a look at an example:

=MAX(C2:C11)

Since the range C2: C11 doesn't contain numbers, the above MAX formula returns 0.

In this tutorial, you've learned how to use the Excel MAX functionMAX() is a function used to get the largest value in a group of values.

Leave a Reply

Your email address will not be published. Required fields are marked *