MAXA function - The function returns the largest value in a set of values including text and logical values in Excel

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

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!

Kareem Winters

Update 19 May 2020

You should read it

May be interested

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], ...)
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], ...)
VAR.S function - Function that calculates variance based on a sample, ignoring logical values and text in Excel
var.s function: function that calculates variance based on a sample, ignoring logical values and text. support functions from excel 2010 onwards. syntax: var.s (number1, [number2], ...)
VAR.P function - Function that calculates variance based on the entire set, ignoring logical values and text in Excel
var.p function: function that calculates variance based on the entire set, ignoring logical values and text. support functions from excel 2010 onwards. syntax: var.p (number1, [number2], ...)
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.inc function: the function returns the rank of a value in a dataset as a percentage including values 0 and 1. the function supports excel 2010 and later versions. syntax: percentrank.inc (array, x, [significance])
QUARTILE.EXC function - The function returns the quartile of a dataset without values 0 and 1 in Excel
quartile.exc function: the function returns the quartile of the data set, with percentile values from 0 to 1 excluding 0 and 1. the support function is from excel 2010 onwards. syntax: quartile.exc (array, quart)
MINA function in Excel, how to use and examples
the mina function in excel helps determine the smallest value in a range of numbers, including logical values and text numbers. with simple syntax, mina supports optimizing the calculation process in spreadsheets.
MODE.MULT function - The function returns a vertical array of the most common values in Excel
mode.mult function: the function returns a vertical array of the most frequently occurring values, or repeating values in an array or data range. support functions from excel 2010 onwards. syntax: mode.mult ((number1, [number2], ...)
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.eq function: the function returns the rank of a number in a list of numbers whose size is in correlation with other values. if multiple values have the same rank -> the function returns the highest rank. support functions from execl 2010 version onwards.
RANK.AVG function - The function returns the rank of a number in a list of numbers in Excel
rank.avg function: the function returns the rank of a number in a list of numbers whose size is in correlation with other values. if multiple values have the same rank -> the function returns the average rank. support functions from execl 2010 version and above