Manuals/calci/MINA
Jump to navigation
Jump to search
MINA(n1,n2,n3.........)
MINA(range1,range2,externalrange1............)
There is no limit to how many parameters pass to MINA.
Calci returns the smallest value from set of numbers.
Parameters can be numbers,array,logical values(TRUE counted as 1 and FALSE counted as 0) or references that contain numbers.
Parameters have no numbers, MINA returns 0.
MINA ignores values that cannot be converted into numbers.
Logical values and text represent the number in the reference as not part of evaluation, use MIN function.
| Column1 | Column2 | Column3 | Column4 | |
| Row1 | 2 | 2 | 4 | 5 |
| Row2 | 7 | 8 | 2 | 128 |
| Row3 | FALSE | 67968 | 14 | 15 |
| Row4 | 17 | 18 | 10000 | 20 |
| Row5 | 26 | 67994 | 10020 | 168 |
| Row6 | 4 | 0.850904 | 1.619775 | 0.525322 |
MINA
Lets see an example in (Column3,Row1)
=MINA(B2:B5)
Smallest number from (2,7,FALSE,17) is 0.
Consider another example
=MINA(2,5,TRUE,8,9)
MINA return the smallest number from(2,5,TRUE,8,9)
is 1.
Syntax
Remarks
Examples
Description