MINA
Returns the smallest value in a list of arguments, including numbers, text, and logical values.
StatisticalStatistics & Analysis
What it does
Calculates min value, treating TRUE=1, text/FALSE=0.
Syntax
MINA(value1, [value2], ...)
Arguments
value1(value) — Value or range.
Examples
Min with Logicals
Min of 5 and FALSE.
FORMULA
=MINA(5, FALSE)
RESULT
0
SAMPLE DATA
| A | B | |
|---|---|---|
| 1 | Val1 | Val2 |
| 2 | 5 |