MINA function is used to find the smallest number from a set of values. The difference between MIN and MINA function is that the latter evaluates ‘TRUE’ and ‘FALSE’ values as ‘1’ and ‘0’ respectively.
Get the smallest value in a set of values
A number equivalent to the smallest value
value1– can be a direct value, cell reference or range reference.
value2– [optional] can be a direct value, cell reference or range reference
Numbers in cells formatted as ‘Text’ will be evaluated as ‘0’ by MINA function.