Excel MIN() Function: Smallest Value & Range Analysis

The MIN() function returns the smallest numeric value from a supplied range of numbers.

Task: Calculate =MIN(B2:B6)to find the lowest sales figure. Edit any salesperson's number below to see the minimum update immediately:

Experiment: Currently the Mouse is the lowest at ₹1,500. Change the Mouse price to ₹2,500 and observe how the minimum updates automatically:

Business Requirement: The sales manager wants to track the smallest order placed today to inspect low-ticket checkout sizes:

Instead of typing individual arguments like =MIN(B2, B3, B4, B5, B6, B7, B8), use range syntax =MIN(B2:B8):

Key Distinction: =MIN(B2:B6) returns 65. It does notreturn "Rahul".

MIN() can evaluate entire two-dimensional matrices across rows and columns simultaneously:

The standard =MIN() function evaluates every numeric cell in the target range unconditionally.

Review the 6-month revenue ledger below. Identify the lowest monthly performance:

Test your formula selection skills:

When MIN() evaluates a range like =MIN(A1:A5):

• Blank / Empty Cells: Ignored completely (they are NOT treated as 0).
• Text Strings & Labels: Ignored in cell range references.
• Negative Numbers: Fully evaluated (e.g. -50 is smaller than 10).

Scenario: You are auditing an e-commerce sales ledger. Enter the formula to calculate the smallest order in column C (Range: C2:C8):

Test your understanding of MIN() ranges, text handling, and value vs label mechanics:

Production guidelines for using =MIN():

• Lock Table Ranges with F4: When copying formulas across summary sheets, use absolute references like =MIN($C$2:$C$100).
• Pairing with Lookups: To find the salesperson or product corresponding to the minimum value, combine MIN with XLOOKUP(MIN(B2:B10), B2:B10, A2:A10).
• Zero vs Blank Verification: Ensure zero-sales rows are intended as 0, as 0 will become the minimum value.