The Excel MINA Function

Home » Excel-Built-In-Functions » Excel-Statistical-Functions » Excel-Mina-Function Search this site: Custom Search Basic Description

Related Functions:  MIN Function MAXA Function MAX Function LARGE Function SMALL Function

The Excel MINA function returns the smallest value from a supplied set of numerical values, while counting text and the logical value FALSE as the value 0 and counting the logical value TRUE as the value 1.

The syntax of the function is :

where the number arguments are a set of one or more numeric values, or arrays of numeric values, that you want to return the smallest value of. These values can be supplied either directly to the function, as cells containing numeric values, or as values returned from other excel formulas.

In Excel 2007 & Excel 2010, you can provide up to 255 number arguments to the Mina function, but in Excel 2003 or earlier, you can only provide up to 30 number arguments.

Excel Mina vs. Excel Min

The Mina function is very similar to the Min Function function. The only difference is when an argument is supplied to the function as a reference to a cell or an array of cells. In this case the Min function ignores logical and text values, while the Mina function counts the logical value TRUE as 1, the logical value FALSE as 0 and text values as 0.

Excel Mina Function Example

The following spreadsheet shows examples of use of the Mina function.

The function formats are shown in the spreadsheet on the left and the results are shown in the spreadsheet on the right.

Formulas:

Results:

Further examples of the Excel Mina function can be found on the Microsoft Office website.

Mina Function Error

If you get an error from the Excel Mina Function, this is likely to be the #VALUE! error: