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

QUARTILE.EXC function - The function returns the quartile of a dataset without values 0 and 1 in Excel
MAXA function - The function returns the largest value in a set of values including text and logical values in Excel

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 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 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 3

- Press Enter -> maximum value is:

MAX 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 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 6

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

Good luck!

Isabella Humphrey

Update 19 May 2020

You should read it

May be interested

STDEV.S function - The function returns the standard deviation based on a sample in Excel
stdev.s function: the function returns the standard deviation based on a sample, ignoring logical values and text. standard deviation is a measure of the dispersion of values against the mean. support functions from excel 2010 onwards. syntax: stdev.s (number1, [number2], ...)
PROB function - The function returns the probability that values in a range are between two limits in Excel
prob function: the function returns the probability that values in a range are between two limits. syntax: prob (x_range, prob_range, [lower_limit], [upper_limit])
TREND - The function returns values in a linear trend in Excel
trend: the function returns values in a linear trend. syntax: trend (known_ys, [known_xs], [new_xs], [const])
FORECAST function - The function returns a value along a linear trend in Excel
forecast function: the function performs the calculation or prediction of a future value by using current values using linear regression. in excel 2016 this function is replaced by forecast.linear function. syntax: forecast (x, known_ys, known_xs)
PERCENTILE function - The function returns the kth percentile in Excel
in mathematical computing, the percentile is a frequently applied process to study the percentile of values in a defined data set. the following article details how to use the percentile function to calculate the kth percentile value.
LARGE function - The function returns the kth largest value in a dataset in Excel
large function: the function returns the kth largest value in a dataset. use the function to determine the position of the value in a dataset. syntax: large (array, k)
INTERCEPT function - The function returns the point at which the line will intersect the y-axis by using the existing x and y values in Excel
intercept function: the function returns the point at which the line will intersect the y-axis by using existing x and y values. use the function when you want to determine the value of a dependent variable when the independent variable is 0. syntax: intercept (known_ys, known_xs)
PERCENTILE.EXC function - The function returns the kth percentile of values in the range, with k in the range from 0 to 1 in Excel
percentile.exc function: the function returns the kth percentile of values in the range with k in the range from 0 to 1, excluding values 0 and 1. syntax: percentile.exc (array, k)
How to use the SUBTOTAL function in Excel
the subtotal function in excel is used in many different cases, helping you to sum subtotals in a list or database, unlike the sum function in excel such as counting cells, calculating average, finding the largest / smallest value. or sum the filtered list values in excel
ERROR.TYPE function - The function returns the number corresponding to one of the error values in Microsoft Excel
error.type function: the function returns the number corresponding to one of the error values in microsoft excel, or the # n / a error if there are no errors. syntax: error.type (error_val)