Menu
EXCEL MINA FUNCTION
Excel MINA Function Introduction
This Function returns the smallest value from a list of parameters, which may include logical values and text.
Description of Excel MINA Function
Syntax:
=MINA(value1, [value2], …)
Parameter list:
Value1st, 2nd, 3rd,… The first value is mandatory; following values are optional. 1 to 255 numbers for which you wish to find the lowest value
Step By Step Guide of MINA Function
In this example, we are given a list of arguments as =MINA(A2:A6,A4:A8,A2:A5) and it returns smallest value 54 as result.
Key Points
- Arguments can be numerals, labels, collections, or referrals that include numbers, text representations of numbers, or logical values in a reference, such as TRUE and FALSE.
- When an argument is an array or a reference, just the values in that array or reference are utilized.
- Blank cells and textual values in the array or reference are discarded.
- TRUE logarithmically equals 1 and FALSE logarithmically equals 0. (zero).
- Errors are caused by arguments that are error values or language that cannot be converted into numbers.
- Use the MIN procedure if you don’t need to include logical numbers and textual representations of integers in a reference in the computation.
- This function is similar to the MIN function, except that it includes logical values and text representations of integers in a reference in the computation.
Related Functions
HLOOKUP Function
HLOOKUP Function
Explore NowVLOOKUP Function
VLOOKUP Function
Explore NowINDEX Function
INDEX Function
Explore NowMATCH Function
MATCH Function
Explore NowDATE Function
DATE Function
Explore NowIF Function
IF Function
Explore NowOR Function
OR Function
Explore NowAND Function
AND Function
Explore NowRANK Function
RANK Function
Explore NowSUMIF Function
SUMIF Function
Explore NowXIRR Function
XIRR Function
Explore NowWORKDAYS Function
WORKDAYS Function
Explore Now
