Functions
MINA
Minimum including booleans and text
Try it
When to use it
When should I use MINA instead of MIN?
Use MINA when your range may contain logical values (TRUE/FALSE) or text strings and you want them counted — MINA treats TRUE as 1, FALSE and text as 0, so a text cell can become the minimum. MIN silently ignores non-numeric cells.
Used in
Syntax
MINA(value1,...)Examples
=MINA({5,10,"hello",20}) // => 0
=MINA({1,2,3,4,5},26,4) // => 1
=MINA({-5,10,"text",20}) // => -5