MIN

Returns the smallest value from a set of numbers or cell references to identify minimum results in a dataset.

The MIN function returns the smallest number from a set of values. It evaluates the provided numbers or node references and identifies the lowest value among them. This function is commonly used in data analysis to determine minimum values, lower limits, or least-performing results within a dataset.

Syntax

MIN (value1,[value2]....)

Arguments

value1 - The numbers or names, arrays, or references that contain numbers. This is a required argument.

value2... - The numbers or names, arrays, or references that contain numbers. This is an optional argument.

Example

MIN (COLUMN1,COLUMN2,COLUMN3)

In the example below, the Min Values measure is created using the MIN function, which returns the smallest value among MEASURE 1, MEASURE 2, and MEASURE 3.

Applying MIN Function

Excel Equivalent

MIN