Manuals/calci/MIN1

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