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!