# 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:

#### 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.