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.

Frequently Asked Questions

What is the MINA Function?
The MINA function is a built-in function of Sourcetable that returns the smallest value in a list of arguments.
What types of arguments can be used with the MINA Function?
The MINA function accepts numbers, names, arrays, or references as arguments.
Do I have to use numbers as arguments in the MINA Function?
Yes, the arguments must contain numbers, either directly or through text representations.
What happens with empty cells and text in the arguments of the MINA Function?
The MINA function ignores empty cells and text in the arguments.

Related Functions

Sourcetable Logo

Work smarter

Al is here to help. Leverage the latest models to
analyze spreadsheets, enrich data, and create reports.

Drop CSV