MAX function - The function returns the largest value in a set of 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.
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:
- In the cell to calculate enter the formula : = MAX (D6: D10)
- Press Enter -> maximum value is:
- 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:
- Where the number values are not numbers -> the function returns the value 0
Above are instructions and some specific examples when using the MAX function in Excel.
Good luck!
You should read it
- 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
- QUARTILE.INC function - The function returns the quartile of a dataset including values 0 and 1 in Excel
- MODE.MULT function - The function returns a vertical array of the most common values in Excel
- RANK.EQ function - Function returns the rank of a number in a list of numbers, returns the highest rank when multiple values with the same rank in Excel
- RANK.AVG function - The function returns the rank of a number in a list of numbers in Excel
- FORECAST function - The function returns a value along a linear trend in Excel
- STDEV.P function - The function returns the standard deviation based on the whole in Excel
- STDEV.S function - The function returns the standard deviation based on a sample in Excel
- PERCENTRANK.INC function - The function returns the rank of a value in a dataset as a percentage including values 0 and 1 in Excel
- PERCENTRANK.EXC function - The function returns the rank of a value in a dataset as a percentage excluding values 0 and 1 in Excel
- PERCENTILE function - The function returns the kth percentile in Excel
Maybe you are interested
AMD has surpassed Intel in brand value
SQL way to count NULL and NOT NULL values in a column
Comparing Odroid-N2+ and Raspberry Pi 4: Which option offers better value?
How to receive free gifts from IObit with a total value of nearly 150,000 USD
Write a program to find duplicate values in Python
Write a program to check duplicate values in Python