Manuals/calci/MIN1
Jump to navigation
Jump to search
MIN(n1,n2,n3.........)
MIN(R1,R2,external R1............)
There is no limit to how many parameters pass to MIN.
This function returns the smallest number from set of numbers.
Parameters can be numbers,array or references that contain numbers.
Parameters have no numbers, MIN returns 0.
| Column1 | Column2 | Column3 | Column4 | |
| Row1 | 2 | 2 | 2 | 0 |
| Row2 | 7 | 5 | ||
| Row3 | 12 | 8 | ||
| Row4 | 17 | 9 | ||
| Row5 | 0 | |||
| Row6 |
MIN
Lets see an example
=MIN(B2:B5)
Smallest number from (2,7,12,17) is 2.
Consider another example
=MIN(2,5,8,9,0)
MIN return the smallest number from(2,5,8,9,0) is 0.
Syntax
Remarks
Examples
Description