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

MAX() is a function to get the largest number in a set of numbers.

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

#### Finding the largest number in a group of numbers

The following examples get the max value among 10, 30, 20, 20, 80, and 50:

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

The above formula returns 80.

Next, let's see more examples below.

Demo data:

#### Finding the largest number in a single range of cells

You can find the largest number in a range of cells, as the following example shows:

=MAX(F2:F11)

MAX() returns 9600, which is the largest number in the range F2: F11.

#### Finding the largest number in multiple ranges of cells

You can find the largest number in multiple ranges, as the following example shows:

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

The above formula returns 10000.

#### MAX() Ignores text, empty cells, or logical values

MAX() ignores text, empty cells, or logical values.

MAX() returns 0 if the arguments contain no numbers.

Here is an example:

=MAX(C2:C11)

The above formula returns 0 because there isn't a number in the range.

In this tutorial, you've learned how to use the Excel MAX function

MAX is a function to get the largest number in a group of numbers.