The MAX formula with example in Excel

The MAX function in Excel is used to find the largest number in a set of values. This function can be useful when you need to determine the highest value in a range of numbers, such as the highest sales figure, the maximum score, or the peak value in a dataset.

Syntax

MAX(number1, [number2], ...)

• number1, number2, ...: These are the numbers or ranges of numbers from which you want to find the maximum value. You can include individual numbers, cell references, or ranges.

Example

Suppose you have a list of sales figures for a week, and you want to find the maximum sales figure for that week.

Data

A
150
200
175
220
180
190
210

You want to find the highest sales figure from this list.

Steps

1. Enter the sales figures in column A (A1).

2. Use the MAX function to find the maximum sales figure. In cell B1, enter the following formula:

   =MAX(A1:A7)
   

3. Press Enter.

Result

The formula returns 220, indicating that the highest sales figure in the list is 220.

Explanation of the Formula

• A1:A7 is the range containing the sales figures.

Another Example with Multiple Ranges

Suppose you have sales figures for two weeks and you want to find the maximum sales figure across both weeks.

Data

Week 1	Week 2
150	180
200	210
175	190
220	230
180	220

You want to find the highest sales figure from both weeks.

Steps

1. Enter the sales figures for Week 1 in column A (A1) and Week 2 in column B (B1).

2. Use the MAX function to find the maximum sales figure across both weeks. In cell C1, enter the following formula:

   =MAX(A1:A5, B1:B5)
   

3. Press Enter.

Result

The formula returns 230, indicating that the highest sales figure across both weeks is 230.

By using the MAX function, you can quickly determine the highest value in a dataset, whether it consists of a single range or multiple ranges of numbers. This is particularly useful for data analysis, reporting, and making informed business decisions.