The MINA Excel function returns the minimum value in an array or range of cells. The function works similar to the MIN function. While the MINA function includes logical values in how it evaluates the values, the MIN function ignores them. In this guide, we’re going to show you how to use the MINA Excel function and also go over some tips and error handling methods.
Supported versions
- All Excel versions
MINA Excel Function Syntax
MINA(value1,[value2],...)
Arguments
value1 | The first value or values you want to find the minimum within. You can enter a static value like 4, a cell reference like B6, or a cell range like B2:B8. |
[value2] | Optional. The second value or values up to 254 arguments. |
MINA Excel Function Example
=MINA(B5:B9)
The function evaluates any string values in a data set as 0. As a result, if your range contains a string with positive numbers, the function returns 0.
Tips
- The MINA Excel function evaluates the logical and string values. However; please keep in mind that date or time values are serial evaluated as numbers in Excel, not strings.
- TRUE logical value = 1
- FALSE logical value = 0
- String values = 0
- We recommend using the MIN function to ignore anything except for numbers.
- Use the MINIFS function to find the minimum number that meets specified conditions.
- The opposite of this function is the MAXA function, which returns the minimum number in an array.