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.

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.

How to use MINA Function in Excel ?
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.

How to use MINA Function in Excel ?

The values are from A3:A8.

STEP 4:

Press Enter to get the results.

How to use MINA Function in Excel ?

It returns 0, since the smallest value among the list is 0.

Subscribe to Blog via Email

Enter your email address to subscribe to this blog and receive notifications of new posts by email.

Hey, wait!Subscribe to Blog via Email

Enter your email address to subscribe to this blog and receive notifications of new posts by email.