Function: MIN

by | Mar 27, 2019 | Excel Formulas

excel min function

The Excel MIN function returns the minimum value in an array or range of cells. In this guide, we’re going to show you how to use the MIN function and also throw in some tips and error handling methods.

Supported versions

  • All Excel versions

Excel MIN Function Syntax

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

Arguments

number1

The first number or numbers where you want to find the minimum. You can enter a static number like 4, a cell reference like B6, or a cell range like B2:B8.

[number2]

Optional. The subsequent number or numbers, up to 255 inputs.


Examples

Static values

=MIN(78,84,78,109,85,100)
formula returns the minimum number in the arguments entered.

Individual cells

=MIN(G3,H3,I3,J3,K3,L3)
formula evaluates all values in the cells.

Range

=MIN(G3:L3)
formula looks up the value of each cell in the range reference. Any valid range can be used with the MIN function.

Download Workbook

Tips

  • The Excel MIN function ignores string values. However, keep in mind that Excel executes date or time values as numbers, not strings.
  • Use the MINIFS function to find the minimum number that meets specific conditions.
  • The opposite of this function is the MAX function which returns the minimum number in an array.

Issues

Error

If there is an error in referred cells or ranges, the MIN function returns the same error.