How to use the Excel MINA function

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:

mina function excel - How to use the Excel MINA function

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

1.1 Syntax: =MINA(E2:E9)

Result:

mina function - How to use the Excel MINA function

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

Result:

mina function in excel - How to use the Excel MINA function

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

Result:

mina function excel 1 - How to use the Excel MINA function

Add a Comment

Your email address will not be published. Required fields are marked *