MS Excel: MinA Function
In Excel, the MinA function returns the smallest value from the values provided. The MinA function compares numbers, text, and logical values (TRUE or FALSE).
The syntax for the MinA function is:
MinA( value1, value2, ... value_n )
value1, value2, ... value_n are numbers, text representations of numbers, or logical values.numeric values. There can be up to 30 values entered.
Applies To:
- Excel 2007, Excel 2003, Excel XP, Excel 2000
For Example:
Let's take a look at an example:
Based on the Excel spreadsheet above:
=MinA(B2, B3) would return 0.23 =MinA(B2:B4) would return 0.23 =MinA(B2:B6) would return 0 (as TRUE evaluates to 1 and FALSE evaluates to 0) =MinA(B2, B3, -1.6) would return -1.6