MINA

Definition: MINA is a function that returns the minimum value in a range of cells, and treats text and logical values as numbers.

Syntax: =MINA(number1, [number2], …)

Situation: This formula is appropriate when you need to find the minimum value in a range of cells, and treat text and logical values as numbers.

Example: If you have a set of numbers 2, 4, 6, and a text value “apple”, the minimum value can be found using the formula =MINA(2, 4, 6, “apple”), which returns 2.