MIN

Statistical Functions

(4.9/5)

Returns the smallest (minimum) value from a set of numbers. MIN finds the lowest numeric value in a range or list of arguments. Essential for identifying lowest values, finding minimums, data analysis, performance tracking, and statistical calculations.

Interactive Formula Tester

Numbers:

Formula:

=MIN("10, 20, 30, 40, 50")

Complete Theory & Understanding

Master the fundamentals of Excel MIN function

Core Concept

The MIN function returns the smallest (minimum) value from a set of numbers. MIN evaluates all numeric values in the provided arguments and returns the lowest one. MIN ignores text values, logical values (TRUE/FALSE), and empty cells. It is one of the fundamental statistical functions for finding extreme values. Essential for identifying lowest values, finding minimums in data analysis, performance tracking, quality control, and statistical calculations. MIN and MAX are complementary functions for finding range boundaries.

Why Use MIN?

Find lowest values
Find minimum performance
Find minimum measurements
Find lower bound or range

Key Characteristics

Returns Smallest

Finds lowest numeric value

MIN(10,20,30) = 10

Ignores Text

Only considers numeric values

MIN(10,"text",30) = 10

Multiple Arguments

Accepts up to 255 arguments

MIN(A1:A10, B1:B10, 5)

Complement to MAX

MIN and MAX are opposites

MIN finds smallest, MAX finds largest

Function Anatomy

=MIN(parameters...)

Required

Parameters:

Function-specific parameters

Returns

Return Value:

Function-specific return type

Primary Use Cases

Data Analysis

Find lowest values

Performance Tracking

Find minimum performance

Quality Control

Find minimum measurements

Statistical Analysis

Find lower bound or range

Theory Summary

Precise

Exact matching required

Position-Based

Returns numeric position

Error-Safe

Handles missing text gracefully

Syntax & Parameters

=MIN(number1, number2)

Required

number1:

First number, cell reference, or range.

Optional

number2:

Additional numbers, cell references, or ranges (up to 255 arguments).

Returns

Return Value:

The smallest (minimum) value

Description: Returns the smallest value from a set of numbers

Interactive Examples

Basic MIN

Find minimum value

Input Text:

"10, 20, 30, 40, 50"

Formula:

=MIN(10, 20, 30, 40, 50)

Result:

Returns 10, the smallest value in the set. MIN finds the lowest number from all arguments.

VBA Implementation & Automation

Basic MIN in VBA

Use MIN function in VBA

' Basic MIN in VBA
Range("C1").Value = Application.WorksheetFunction.Min(Range("A1:A10"))
' Returns: Minimum value

' Find minimum
Sub FindMinimum()
    Dim minValue As Double
    minValue = Application.WorksheetFunction.Min(Range("A1:A10"))
    Range("B1").Value = minValue
End Sub

' Find minimum across multiple ranges
Sub MinMultipleRanges()
    Dim minValue As Double
    minValue = Application.WorksheetFunction.Min( _
        Range("A1:A10"), _
        Range("B1:B10"), _
        Range("C1:C10"))
    Range("D1").Value = minValue
End Sub

' Calculate range (MAX - MIN)
Sub CalculateRange()
    Dim maxValue As Double
    Dim minValue As Double
    Dim rangeValue As Double
    maxValue = Application.WorksheetFunction.Max(Range("A1:A10"))
    minValue = Application.WorksheetFunction.Min(Range("A1:A10"))
    rangeValue = maxValue - minValue
    Range("B1").Value = "Range: " & rangeValue
End Sub

' Compare MIN with SMALL
Sub CompareMinSmall()
    Dim minValue As Double
    Dim smallValue As Double
    minValue = Application.WorksheetFunction.Min(Range("A1:A10"))
    smallValue = Application.WorksheetFunction.Small(Range("A1:A10"), 1)
    Range("B1").Value = "MIN: " & minValue
    Range("B2").Value = "SMALL(1): " & smallValue
    ' Should be equal
End Sub

Business Applications

Data Analysis

Find lowest values in analysis

=MIN(data_range)

Performance Tracking

Find minimum performance metrics

=MIN(performance_data)

Quality Control

Find minimum measurements

=MIN(measurements)

Statistical Analysis

Find lower bound or range

=MAX(values) - MIN(values)

Common Issues & Solutions

Returns 0 Unexpectedly

MIN returns 0 when all values are positive

Check: MIN(0, 5, 10) = 0 (0 is smallest)

Solution: MIN returns 0 only if 0 is the smallest value, or if 0 is present among all values. Check if you actually have smaller positive values. MIN finds the smallest value.

Negative Values

MIN returns negative value

MIN includes negatives: MIN(-10, -5) = -10

Solution: This is correct. MIN includes negative values. MIN(-10, -5, 5) = -10. MIN(-10, -5) = -10 (most negative). MIN always finds the smallest value, which can be negative.

Text Values Ignored

Text that looks like numbers not included

Use VALUE() to convert text to numbers

Solution: MIN only considers actual numeric values. Text that looks like numbers (e.g., "100") is ignored. Convert text to numbers first: VALUE("100") or fix data format.

Conditional Minimum Needed

Need minimum with conditions

Use MINIFS for conditional minimum

Solution: MIN finds overall minimum. For conditional minimum, use MINIFS: MINIFS(data_range, criteria_range, criteria). MINIFS finds minimum value meeting specific criteria.