Excel - MAX and MIN Functions: Finding the Largest and Smallest Values

Buzz

Ngày cập nhật gần nhất: 1/8/2025

In Excel, there are numerous statistical functions, and MAX and MIN functions are among the most commonly used ones to return the maximum and minimum values of arguments or a range of data containing numbers.

To better understand the syntax and usage of the MAX and MIN functions to find the maximum and minimum values of arguments or data ranges, the following article by Mytour will introduce you to the syntax, functions, and illustrated examples in specific cases.

How to Use MAX and MIN Functions in Excel

Syntax:

- MAX (number 1, number 2, …)

- MIN (number 1, number 2, …)

Where: Number 1, number 2 are arguments or data ranges.

Function: Returns the maximum or minimum value of the arguments or data range containing numbers.

Example 1:

- Finding the maximum value in the sequence of numbers 10, -20, 3, 4, 11

The formula will be: MAX (10, -20, 3, 4, 11) = 11.

- Find the minimum value among the numbers: 20, 100, 30, 45.

The formula will be: MIN (20, 100, 30, 45) = 20.

Example 2: Find the maximum value in the following data table

- Based on the student list table, we find the highest score in the Mathematics result list

- Apply the MAX function to find the maximum value of the column “Math”.

- The formula applied to cell D15 is as follows: D15 = MAX (D6:D14)

The result obtained is:

Example 3: Find the minimum value in the following data table

- Referring to the Student List table, find the lowest Mathematics score in the Mathematics score list of all students.

- Apply the MIN function to find the minimum value of the column “Math”.

- The formula for cell D15 is as follows: D15 = MIN(D6:D14)

The result obtained is:

In our previous guide, we walked you through using the MAX and MIN functions in Excel with specific examples. We hope you've gained insight into the syntax, functionality, and application of these common statistical functions in Excel. Additionally, you can explore and utilize Excel tricks available on Mytour to enhance spreadsheet operations more efficiently. Similar to the min function, you can refer to MINA Function, a function that returns the smallest value.

Frequently Asked Questions

What is the syntax for using MAX and MIN functions in Excel?

The syntax for the MAX function is MAX(number 1, number 2, …), and for the MIN function, it is MIN(number 1, number 2, …). These functions return the maximum or minimum value from a set of numbers or data ranges.

How can I find the maximum value in a range using Excel?

To find the maximum value in a range in Excel, you can use the formula MAX(D6:D14), where D6:D14 represents the range of cells containing your data. This will return the highest number in that range.

Is it possible to use MIN function to find the lowest score in a table?

Yes, you can use the MIN function to find the lowest score in a table by applying the formula MIN(D6:D14), which will return the minimum value from the specified range of cells.

Can you provide examples of using MAX and MIN functions in Excel?

For example, to find the maximum value from the numbers 10, -20, 3, 4, and 11, use MAX(10, -20, 3, 4, 11), which results in 11. Similarly, use MIN(20, 100, 30, 45) to find the minimum value, which will be 20.

Mytour's content is for customer care and travel encouragement only, and we are not responsible.

For errors or inappropriate content, please contact us at: [email protected]