In this post, you’ll learn about MINA Function, syntax and the way of using MINA Function in Excel spreadsheet.
What is MINA Function?
The Excel MINA Function calculates and returns the smallest numeric value in a given data. MINA Function ignores empty cells but calculates logical values as 1 and 0.
In financial analysis, MINA can be useful in calculating minimum numeric value and ignoring empty cells. MINA Function introduced in MS Excel 2007.
Syntax
=MINA(value 1, [value 2],…)
Arguments:
- = – built-in function.
- MINA() – function name.
- value 1 – (required) is a reference or range that contains a numeric value.
- value 2 – (optional) is a reference that contains a numeric value.
Notes:
- Ignores empty cells.
- MINA Function evaluates TRUE and FALSE as 1 and 0.
- Arguments can be provided as numbers, names, arrays, references logical values, or text.
- If arguments contain no numbers, MINA returns 0.
- In a cell, a ‘number as text’ is calculated as zero.
- #VALUE! Error – if the values are supplied directly as non-numeric.
Difference between MIN Function and MINA Function
MIN FUNCTION | MINA FUNCTION |
MIN Function returns the smallest numeric value of the data. | MINA Function returns the smallest numeric value of the data. |
Ignores logical value. | Calculates TRUE and FALSE as 1 and 0. |
Calculates text values of numbers when directly given as values in the cell. | Calculates text values of numbers when directly given as values in the cell. |
Ignores text values. | Calculates text values as 0. |
How to use MINA Function in Excel ?
MINA Function is used to calculate the smallest value of the given data.
Example:
STEP 1:
Open the workbook in your Microsoft Excel.
STEP 2:
Enter the data in the workbook.
STEP 3:
In the new cell, give the formula of the function or the syntax. Always start with ‘ =’ for every functions, MINA Function name, followed by the open parenthesis, to the arguments of the syntax.
The values are from A3:A8.
STEP 4:
Press Enter to get the results.
It returns 0, since the smallest value among the list is 0.