## 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 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 (
**value1**,**value2**, ...) 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:

A | B | C | D | E | F | |
---|---|---|---|---|---|---|

1 | Date | Item Code | Item Name | Qty | Unit Price | Amount |

2 | 12/4/2019 | Item0001 | HP Desktop White 1 | 2 | 1200 | 2400 |

3 | 12/4/2019 | Item0002 | HP Desktop Black 2 | 1 | 1240 | 1240 |

4 | 12/5/2019 | Item0003 | HP Desktop Blue 3 | 3 | 1130 | 3390 |

5 | 12/5/2019 | Item0003 | HP Desktop Blue 3 | 4 | 1130 | 4520 |

6 | 12/5/2019 | Item0002 | HP Desktop Black 2 | 5 | 1240 | 6200 |

7 | 12/6/2019 | Item0001 | HP Desktop White 1 | 1 | 1120 | 1120 |

8 | 12/7/2019 | Item0001 | HP Desktop White 1 | 7 | 1150 | 8050 |

9 | 12/9/2019 | Item0003 | HP Desktop Blue 3 | 3 | 1100 | 3300 |

10 | 12/9/2019 | Item0002 | HP Desktop Black 2 | 8 | 1200 | 9600 |

11 | 12/10/2019 | Item0003 | HP Desktop Blue 3 | 2 | 1000 | 2000 |

**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 T**ext, 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 function**. **MAX**() is a function used to get the largest value in a group of values.