The MINA function returns the smallest numeric value in a set containing any values.
MINA(value, value…)
value: Any value or a collection containing any values. Date/time values or duration values can’t be mixed with other value types. If either of these value types is included, all values must be of the same value type. A string value can be included in a referenced cell, but can’t be entered directly as an argument to the function.
value…: Optionally include one or more additional values or collections.
Notes
A string value included in a referenced cell is given a value of 0. The boolean value FALSE is assigned a value of 0 and the boolean value TRUE is assigned a value of 1.
Examples |
|---|
=MINA(1, 2, 3, 4) returns 1. =MINA(A1:C1) returns -10, where A1:C1 contains -1, -10, hello. =MINA(A2:C2), returns 0, where A2:C2 contains 1, 10, hello. |