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.
Excel Functions in Alphabetical Order (Complete list)
Complete List of Excel Functions (Category wise)
New Dynamic Array Functions in Excel