Manuals/calci/MINA1
Jump to navigation
Jump to search
'
MINA(n1,n2,n3.........)
MINA(R1,R2,external R1............)
There is no limit to how many parameters pass to MINA.
This function returns the smallest value from set of numbers.
Parameters can be numbers,array,logical values.
TRUE counted as 1 and 0 counted as FALSE
Parameters have no numbers, MINA shows 0.
| Column1 | Column2 | Column3 | Column4 | |
| Row1 | 3 | 0 | 5 | 1 |
| Row2 | 5 | 2 | ||
| Row3 | 0 | TRUE | ||
| Row4 | 20 | 6 | ||
| Row5 | 10 | |||
| Row6 |
MINA
Lets see an example in (Column3,Row1)
=MINA(B2:B5)
Smallest number from (3,5,0,20) is 0.
Consider another example
=MINA(5,2,TRUE,6,10)
MINA return the smallest number from(5,2,TRUE,6,10)
is 1.
Syntax
Remarks
Examples
Description