Returns the minimum value in a dataset.
Sample Usage
MINA(20,30)
MINA(A2:A6)
MINA(A1:B2,5)
Syntax
MINA(value1, [value2, ...])
- value1 - The first value or range to consider while calculating the minimum value.
- value2, .. - [OPTIONAL] Additional numbers or ranges to consider.
Examples
MINA(20,30) returns the value 20.
MINA(A2:A6) returns the smallest value in the ranges A2 through A6.
MINA(A1:B2,5) returns the smallest value among the values contained in cells A1 through B2 and the number 5.
Notes
- Arguments can be numbers; names, arrays, or references that contain numbers; text representations of numbers; or logical values, such as TRUE and FALSE.
- Arguments that contain TRUE evaluate as 1; arguments that contain text or FALSE evaluate as 0 (zero).
- Cells with text will be assigned the numeric value 0 (zero) for the purpose of this function.
- Arguments that are error values or text that cannot be translated into numbers cause errors.
- If you do not want to include logical values and text representations of numbers in a reference as part of the calculation, use the MIN function.