The MINA function is a function that returns the smallest value including logical values and a written representation of numbers. If you are looking to use this function, please refer to the following article with syntax, for example MINA function.
The function of the MINA function in Excel is to find the smallest value in a given range of cells, elements. The syntax and usage of the MINA function are quite simple, please follow the article below of Software to understand how to use this function.
MINA function and examples
HOW TO USE THE MINA FUNCTION IN EXCEL – ILLUSTRATIVE EXAMPLE
Syntax: MINA(Value1, [value2], [value3],…)
Where:
– Value1 is the required argument.
– Value2, Value3,… are options.
Value1, Value2,… arguments be it digits, names, sequences of cells (C1:C5), reference values (=C5), logical values: TRUE (with a value of 1) or FALSE (with a value of 0), or alphanumeric numbers (one, two, three…), this function calculates the value of that cell as 1.
Illustrative examples: For the transcripts of some students, find the smallest value in the Scores column
To find the minimum value, use MINA with the formula
Cell C11 is: MINA(D5,D6,D7,D8,D9) or MINA(D5 :D9)
We get the result:
It is easy to use the MINA function to find the minimum value of the sequence of numbers, find the lowest scores of the students in the class, … and many other practical applications.
https://thuthuat.taimienphi.vn/ham-mina-trong-excel-959n.aspx