# MINA Function in Excel

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.

## 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.