Return the smallest value in Excel
Returns the minimum value in a list of arguments, ignoring logical values and text


Return the smallest value.


The Excel MIN function returns the smallest numerical with the lowest value as per given reference of cell range.
For example, if A1:A5 contains a list of numbers (2,8,10,5,6) in a column and user want to find the smallest amount, the formula can be =MIN(A1:A5) that find the lowest number as 2.


=MIN (number1, [number2], …)


number1 – First number or range of cells containing numerical values
number2 [optional] – Second number or range of cells containing numerical values.
The function can handle between 1 to 255 range or criterion pairs.

Return Value

The smallest Integer

Key Notes

  • The MIN function returns the lowest among the reference cell.
  • Use the MAX function to find the largest value of a data set.
  • Arguments can either be numbers or names, arrays, or references that contain numbers.
  • MIN returns 0 (zero) if none of the arguments listed value is numeric.
  • MIN function ignores empty cells.

Keep Reading Similar Functions:

Return the largest value in Excel


The MAX function returns the highest value as per cell range, if A1:A5 contains a list of numbers (2,8,10,5,6), the formula can be =MAX(A1:A5), returns 10.

Read More »
Find the average of numbers in Excel


The AVERAGE function returns an average of numbers positioned in one or multiple ranges, =AVERAGE(5,15,30) add numbers and divide by 3, and returns 16.67.

Read More »
To add multiple numbers in Excel


The SUM function returns a number after adding multiple numeric arguments together =SUM(5,10,15) the Excel add numbers together and returns 30.

Read More »