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)
formula evaluates the values of cells in the referred range. Any valid range can be used with the MINA function. This example returns 0, because it evaluates TRUE and FALSE values as 1 and 0, respectively. Thus, the function returns 0, because it’s the smallest value in the data set.

Excel MINA Function Example 01

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.

Excel MINA Function Example 02

Download Workbook

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.