MINA function - The function returns the smallest value in the given numbers including text and logical values in Excel

MAXA function - The function returns the largest value in a set of values 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 the MINA function - one of the functions in the statistical function group is very popular in Excel.

MINA function - The function returns the smallest value in the given numbers including text and logical values in Excel Picture 1

Description: The function returns the smallest value in the given numbers including text and logical values.

Syntax: MINA (value1, [value2], .)

Inside:

- value1, [value2], .): The values that you want to find the median, 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.

- A logical value of True is considered 1, and a False value is considered to be 0.

- 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 arguments do not contain numbers -> the function returns the value 0.

- Arguments that are text or error values cannot be converted -> cause errors in the function.

- In case you do not want to include both text and logical values -> use the MIN function .

For example:

Calculate the minimum value of the values in the following data table:

MINA function - The function returns the smallest value in the given numbers including text and logical values in Excel Picture 2

- In the cell to calculate enter the formula : = MINA (D6: D11)

MINA function - The function returns the smallest value in the given numbers including text and logical values in Excel Picture 3

- Press Enter -> the smallest value including the text value and logic is:

MINA function - The function returns the smallest value in the given numbers including text and logical values in Excel Picture 4

- Here the return value is 0 corresponding to the value of False.

- Where True value is the smallest value -> the function returns the value 1

MINA function - The function returns the smallest value in the given numbers including text and logical values in Excel Picture 5

- Where the value of False is the smallest value -> the function returns the value 0.

MINA function - The function returns the smallest value in the given numbers including text and logical values in Excel Picture 6

Above are instructions and some specific examples when using the MINA function in Excel.

Good luck!

Samuel Daniel

Update 19 May 2020

You should read it

May be interested

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])
How to use the MAXA function in Excel, detailed examples
the maxa function in excel helps find the largest value in a data set, including numbers, logical values, and text containing numbers. this is different from the max function, which only counts numbers. let's learn the syntax and usage of the maxa function with practical examples.
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)
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], ...)
MIN function - The function returns the smallest value in the given numbers in Excel
min function: the function returns the smallest value in the given numbers. syntax: min (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.
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], ...)
BINOM.INV function - The function returns the smallest value with cumulative binomial distribution greater or equal to the standard value in Excel
binom.inv function: the function returns the smallest value with cumulative binomial distribution greater or equal to the standard value. support functions from the excel 2010 version. syntax: binom.inv (trials, probability_s, alpha)