# MINA

Formulas / MINA
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]

## Examples

• =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.

## Summary

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.