MIN

Formulas / MIN
Find the smallest value in the data supplied.
=MIN(number1, number2, ...)
  • number1 - required argument
  • number2 - [OPTIONAL] additional argument
  • … - [OPTIONAL] additional arguments

Examples

  • =MIN(12,17,25,11,23)

    The MIN function returns the smallest value from a given set of numbers. For example, this returns 11.

  • =MIN(A1:A10)

    The MIN function can also be used with a range of cells. For example, this returns the minimum value in the range A1:A10.

  • =MIN(5,10)

    The MIN function can also be used to compare two numbers. For example, this returns 5.

  • =MIN(A1,A2,A3)

    The MIN function can also be used to compare multiple cells. For example, the formula returns the smallest value in A1:A3.

  • =MIN(A1:A10,1)

    The MIN function can also be used to compare a range of cells and a single number. For example, the formula returns the minimum value in the range A1:10.

  • =MIN(A1:A10,C1:C10)

    The MIN function can also be used to compare two ranges of cells. For example, the formula returns the minimum value in C1:C10 and A1:A10.


Summary

The MIN function returns the smallest value in a set of numerical, name, array, or reference arguments. It is optional to include the first argument, number1, and additional subsequent arguments.

  • The MIN function returns the smallest value in the data set, ignoring empty cells, text values, logical values (TRUE and FALSE), and numbers entered as text on the worksheet.
  • The MIN function can accept hardcoded constants, cell references, or ranges in any combination.
  • The MIN function ignores null cells.

Frequently Asked Questions

What is the MIN Function?
The MIN function returns the smallest value in a set of values. It takes numerical, name, array, and reference arguments.
What is the first argument of the MIN Function?
The first argument is number1 and is optional.
What kind of arguments can the MIN Function take?
The MIN Function takes numerical, name, array, and reference arguments.
What happens if the MIN Function has empty cells, logical values, or text in its arguments?
The MIN Function ignores empty cells, logical values, and text in name, array, and reference arguments.

Related Functions

Sourcetable Logo

Work smarter

Al is here to help. Leverage the latest models to
analyze spreadsheets, enrich data, and create reports.

Drop CSV