Buzz
The purpose of the MINA function in Excel is to find the smallest value in a given range of cells or elements. The syntax and usage of the MINA function are straightforward. Follow this Mytour guide to understand how to use this function.
Understanding MINA Function and Examples
USING MINA FUNCTION IN EXCEL - ILLUSTRATIVE EXAMPLE
Syntax: MINA(Value1, [value2], [value3],…)
Where:
- Value1 is a mandatory argument.
- Value2, Value3,… are optional.
The arguments Value1, Value2,… can be numbers, names, ranges of cells (C1:C5), reference values (=C5), logical values: TRUE (evaluates to 1) or FALSE (evaluates to 0), or text-formatted numbers (one, two, three…). The function calculates the value of the cell as 1 for such cases.
Illustrative Example: Given a table of students' scores, find the smallest value in the Scores column.
To determine the minimum value, use MINA with the formula
Cell C11: MINA(D5,D6,D7,D8,D9) or MINA(D5:D9)
The result is:
Effortlessly utilize the MINA function to find the smallest value in a series, discover the lowest scores of students in a class, and many other practical applications in real life.
