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

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

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

Remarks

 * This function includes hidden cells.* 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 MINIFS function to satisfy multiple conditions.* You can use the MINVISIBLE - User Defined Function to exclude hidden cells.* You can use the AGGREGATE function to exclude hidden cells.* This is similar to the AVERAGE function.* This is similar to the MAX function.* For the Microsoft documentation refer to support.microsoft.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!