Skip to content

mina

Minimum value, treating text as 0 and TRUE as 1.

v = mina(number1, number2, ...)

Like min but counts text values as 0 and logical TRUE as 1 in the comparison. Counterpart of maxa.

mina(2, 'text', 5) % 0 (text counted as 0)
  • min — Minimum value along a dimension, or elementwise minimum of two inputs.
  • maxa — Maximum value, treating text as 0 and TRUE as 1.
  • minifs — Minimum value among cells meeting multiple criteria.