MINA and MAXA Functions in Excel

This article provides a clear overview of MINA and MAXA Functions in Excel, with the main facts, useful context, and practical details organized for easy reading.

If you do not know the syntax and usage of these two functions, follow the article below. The article describes the syntax and usage of the MINA () and MAXA () functions in Excel.

MINA Function

Description

The MINA () function returns the smallest value in a list of input values that include logical values and textual representations in a reference.

Syntax

= MINA (value1, [value2],.)

Arguments

value1, value2,. are the values you may need to find the smallest value in it, up to 255 values.

Note

- Value1, value2,. can be numbers, names, arrays or references containing numbers.

- If arguments contain TRUE, they are counted as 1, arguments containing text or FALSE are counted as 0.

- If the argument is an array or reference, only the values in it are used, and the text values and empty (empty) values will be ignored.

- If the argument is text or an error value cannot be converted into a number, the MINA () function will return an error.

- If the argument contains no value, MINA () returns 0.

For Example

MAXA Function

Description

The MAXA () function is the function that returns the largest value in the argument list including the logical values and the numerical representation written in a reference. The MAXA () function is similar to the MINA () function.

Syntax

= MAXA (value1, [value2],.)

Arguments

- value1, value2,. are the values you may need to find the largest value in it, up to 255 values.

Note

- Value1, value2,. can be numbers, names, arrays or references containing numbers.

- If arguments contain TRUE, they are counted as 1, arguments containing text or FALSE are counted as 0.

- If the argument is an array or reference, only the values in it are used, and the text values and empty (empty) values will be ignored.

- If the argument is text or an error value cannot be converted into a number, MAXA () will report an error.

- If the argument contains no value, MAXA () returns 0.

For Example

So after this article you can use the MINA () and MAXA () functions to statistic data in Excel. Good luck!