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 MAXA function - one of the functions in the statistical function group is very popular in Excel.
MAXA function - The function returns the largest value in a set of values including text and logical values in Excel Picture 1
Description: The function returns the largest value in a set of values that includes both text and logical values.
Syntax: MAXA (value1, [value2], .)
Inside:
- value1, [value2], .: are the values that want to find the largest value, where value1 is the required parameter, other values are optional and contain up to 255 value 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.
- The argument value is True -> the function defines that value as 1, and the False value is 0.
- 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 do not want to include both the logical value and the text in the function -> use the MAX function .
For example:
Calculate the maximum value of the number values as described in the following data table:
MAXA function - The function returns the largest value in a set of values including text and logical values in Excel Picture 2
- In the cell to calculate enter the formula : = MAXA (D6: D10)
MAXA function - The function returns the largest value in a set of values including text and logical values in Excel Picture 3
- Press Enter -> maximum value is:
MAXA function - The function returns the largest value in a set of values including text and logical values in Excel Picture 4
Here the logical values are still calculated.
- Where the logical value is the largest value in the set of values -> returns the value corresponding to the logical value. The example here 1 is the largest value corresponding to the value True -> the function returns the value 1.
MAXA function - The function returns the largest value in a set of values including text and logical values in Excel Picture 5
- The function returns the maximum value of 0 in case 0 is the largest value corresponding to the value of False.
MAXA function - The function returns the largest value in a set of values including text and logical values in Excel Picture 6
Above are instructions and some specific examples when using MAXA function in Excel.
Good luck!
You should read it
- MINA function - The function returns the smallest value in the given numbers including text and logical values in Excel
- AVERAGEA function - The function returns the average of the arguments including numeric, text, and logical values in Excel
- QUARTILE.INC function - The function returns the quartile of a dataset including values 0 and 1 in Excel
- MINA and MAXA functions in Excel
- MAX function - The function returns the largest value in a set of values in Excel
- VARA - Function that calculates variance based on a sample, including logical values and text in Excel
- STDEVA function - The function of estimating standard deviations based on a sample including both text and logical values in Excel
- STDEV.P function - The function returns the standard deviation based on the whole in Excel
- STDEVPA function - The function of estimating standard deviations based on an entire population including both text and logical values in Excel
- VARPA function - Function that calculates variance based on the entire set, including logical values and text in Excel
- VAR.S function - Function that calculates variance based on a sample, ignoring logical values and text in Excel
- VAR.P function - Function that calculates variance based on the entire set, ignoring logical values and text in Excel
May be interested
MEDIAN function - The function returns the median of the given numbers in Excel
MIN function - The function returns the smallest value in the given numbers in Excel
MINA function - The function returns the smallest value in the given numbers including text and logical values in Excel
MODE.MULT function - The function returns a vertical array of the most common values in Excel
NEGBINOM.DIST function - Function returns the negative binomial distribution in Excel
CONFIDENCE.T function - The function returns the confidence interval of the population by using the Student's t-distribution in Excel