MINA function in Excel returns the smallest value or minimum value from a supplied set of numeric values. Where Text value is considered as 0. Logical Value FALSE is considered as 0 and Logical Value TRUE is considered as 1.
Syntax of MINA Function in Excel:
MINA( number1, [number2], … )
Where the number arguments are one or more numeric values from which you want to find the minimum value in Excel
Example of MINA Function in Excel:
Formula
- Text Value is considered as 0
- Logical Value with FALSE is considered as 0
- Logical Value with TRUE is considered as 1
- In First Example MINA Function takes up the cell reference and finds the minimum value
- In Second Example MINA Function takes up the values directly and finds the minimum value