Excel MAX Function

This tutorial explains how to use the Excel MAX function.

Description

The Excel MAX function get the largest value in a set of values.

Syntax
=MAX(value1, [value2], …)
Arguments

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

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.

Text, empty cells or logical values in the array or reference are ignored.

Example

Here is our sample data.

A B C D E
1 Item Code Item Name Qty Unit Cost ($) Unit Price ($)
2 Item001  Desktop PC 1 21 200.00 225.00
3 Item002  Desktop PC 2 22 150.00 750.00
4 Item003  Desktop PC 3 25 210.00 235.00
5 Item004   Desktop PC 4 25 780.00 785.00
6 Item005   Desktop PC 5 30 1040.00 1010.00
7 Item006   Desktop PC 6 30 230.00 255.00
8 Item007  Desktop PC 7 40 274.00 290.00

Example 1:

=MAX(1,3,2)

In Example 1, MAX returns 3.

Example 2:

=MAX(C2:C8)

In Example 2,  MAX returns the largest value in the range C2:C8. The return value of the MAX formula is 40.

Example 3:

Let’s see another example below.

=MAX(C2:C8, 41)

In Example 3,  as you can see, the largest value in the range C2:C8 (the first argument) is 40 and the second argument is 41. MAX returns 41 which is the largest value.

In this tutorial, you have learned how to use the Excel MAX function. We use the Excel MAX function to get the largest value in a group of values.

Here is a full list of Microsoft Excel functions.