Find the smallest numeric value in a range of values.

`=MINA(value1,[value2],â€¦)`

- value1 - required
- value2 - [OPTIONAL]
- value3 - [OPTIONAL]
- value4 - [OPTIONAL]
- value5 - [OPTIONAL]
- value6 - [OPTIONAL]
- value7 - [OPTIONAL]
- value8 - [OPTIONAL]
- value9 - [OPTIONAL]
- value10 - [OPTIONAL]

`=MINA(12,17,25,11,23)`

The MINA function allows you to find the smallest value from a range of cells. For example, this will return 11, as 11 is the smallest value in the range.

`=MINA(A1,A2,A3)`

You can also use MINA to select a range of cells. For example, this will return the smallest value from the cells A1, A2, and A3.

`=MINA(A1:A10)`

You can use MINA to select a larger range of cells. For example, this will return the smallest value from the cells A1 to A10.

The MINA function is used to return the smallest value from a list of up to 255 arguments, which can include numbers, names, arrays, or references. It ignores empty cells and text values.

- The MINA function returns the smallest value in a range of values, and ignores null cells.
- Logical values (TRUE and FALSE) are evaluated as 1 and 0, while text is evaluated as zero.
- Multiple arguments can be used with the MINA function - these can be hardcoded values, cell references, or range references, in any combinations.

The MINA function is a built-in function of Sourcetable that returns the smallest value in a list of arguments.

The MINA function accepts numbers, names, arrays, or references as arguments.

Yes, the arguments must contain numbers, either directly or through text representations.

The MINA function ignores empty cells and text in the arguments.

Drop CSV