MINA Function in Excel

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

MINA Function in Excel 1

  • 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

Result

MINA Function in Excel 2

previous-small MINA Function in Excel                                                                                                                next_small MINA Function in Excel