The function of MINA function in Excel is to find the smallest value in a given range of cells and elements. The syntax and usage of the MINA function is quite simple, follow the article below of sophuc.com to understand how to use this function.

**Syntax**: =MINA( value1, [value2, … value_n] )

The MINA function syntax has the following arguments:

**value1**: It can be a number, text representation of a number, or logical value.**value2, … value_n**(Optional): They can be numbers, text representations of numbers, or logical values. There can be up to 30 values entered.

**Example**: Let’s look at some Excel MINA function examples and explore how to use the MINA function as a worksheet function in Microsoft Excel:

Based on the Excel spreadsheet above, the following MINA examples would return:

**1.1 Syntax**: =MINA(E2:E9)

**Result**:

**1.2 Syntax**: =MINA(C30:C37,**50**)

**Result**:

**1.3 Syntax**: =MINA(C30:C37,**150**)

**Result**: