MIN(number1 [,number2] [..])

Returns the smallest value in a list or array of numbers.

number1The first number.
number2(Optional) The second number.

Remarks

* This function includes hidden rows.
* Arguments that are numbers are included.
* Arguments that are dates are included.
* Arguments that are zero are included.
* Arguments that are logical values are excluded.
* Arguments that are text are excluded.
* If any cell references are empty, then these are excluded.
* If any cell references contain an error, then that error is returned.
* You can have a maximum of 255 arguments.
* You can use the MINA function to include logical values and text.
* You can use the MINIF - User Defined Function if you want to satisfy one condition.
* You can use the MINIFS function to satisfy multiple conditions.
* You can use the AGGREGATE function to exclude hidden rows.
* For the Microsoft documentation refer to support.office.com

 A
1=MIN(5,2,6,9) = 2
2=MIN(2,4,6,8) = 2
3=MIN(2,"4","6",8) = 2
4=MIN({5,4,3,2,1}) = 1
5=MIN({"some","text"}) = 0
6=MIN("some text") = #VALUE!


© 2019 Better Solutions Limited. All Rights Reserved. © 2019 Better Solutions Limited Top