MAX function - The function returns the largest value in a set of values ​​in Excel

MAX function: The function returns the largest value in the set of values. Syntax: MAX (number1, [number2], ...)

The following article introduces you to MAX - 1 of the functions in the group of statistical functions that are very popular in Excel.

MAX function - The function returns the largest value in a set of values ​​in Excel Picture 1MAX function - The function returns the largest value in a set of values ​​in Excel Picture 1

Description: The function returns the largest value in a set of values.

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

Inside:

- number1, [number2], .) : The values ​​that want to find the largest value, where number1 is the required parameter, other values ​​are optional and contain up to 255 number parameters .

Attention:

- The value of the argument must be a number, name, array or reference containing numbers.

- Logical or text values ​​when typing directly into the argument list -> these values ​​are still counted.

- If the argument is a reference array containing text values ​​or logic -> these values ​​are ignored, but the value 0 is still counted.

- If the value of the argument is not a number -> the function returns the value 0.

- Arguments that are text or error values ​​cannot be converted -> cause errors in the function.

- If you want to include the logical value and text in the function -> use the MAXA function .

For example:

Calculate the maximum value of the number values ​​as described in the following data table:

MAX function - The function returns the largest value in a set of values ​​in Excel Picture 2MAX function - The function returns the largest value in a set of values ​​in Excel Picture 2

- In the cell to calculate enter the formula : = MAX (D6: D10)

MAX function - The function returns the largest value in a set of values ​​in Excel Picture 3MAX function - The function returns the largest value in a set of values ​​in Excel Picture 3

- Press Enter -> maximum value is:

MAX function - The function returns the largest value in a set of values ​​in Excel Picture 4MAX function - The function returns the largest value in a set of values ​​in Excel Picture 4

- Calculate the maximum value in the set of number values and 209 -> enter the formula: = MAX (D6: D10, 209) -> press Enter -> the largest value is:

MAX function - The function returns the largest value in a set of values ​​in Excel Picture 5MAX function - The function returns the largest value in a set of values ​​in Excel Picture 5

- Where the number values ​​are not numbers -> the function returns the value 0

MAX function - The function returns the largest value in a set of values ​​in Excel Picture 6MAX function - The function returns the largest value in a set of values ​​in Excel Picture 6

Above are instructions and some specific examples when using the MAX function in Excel.

Good luck!

4 ★ | 1 Vote