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)
1.2 Syntax: =MINA(C30:C37,50)
1.3 Syntax: =MINA(C30:C37,150)