min

 The MIN function in Excel is used to find the smallest number in a range of values. However, there are several ways to expand and use the MIN function in combination with other functions and data. Below are 10 examples of how you can use the MIN function in Excel, including formulas and sample data.

Example 1: Basic MIN Function

Data:

Copy

A1: 10
A2: 20
A3: 5
A4: 15

Formula:

excel

Copy

=MIN(A1:A4)

Result:

Copy

5

Example 2: MIN with Non-Adjacent Cells

Data:

Copy

A1: 10
B1: 20
C1: 5
D1: 15

Formula:

excel

Copy

=MIN(A1, B1, C1, D1)

Result:

Copy

5

Example 3: MIN with Conditions (Using MINIFS)

Data:

Copy

A1: 10  | B1: "Apple"
A2: 20  | B2: "Banana"
A3: 5   | B3: "Apple"
A4: 15  | B4: "Banana"

Formula:

excel

Copy

=MINIFS(A1:A4, B1:B4, "Apple")

Result:

Copy

5

Example 4: MIN with Logical Conditions (Using Array Formula)

Data:

Copy

A1: 10  | B1: "Apple"
A2: 20  | B2: "Banana"
A3: 5   | B3: "Apple"
A4: 15  | B4: "Banana"

Formula:

excel

Copy

=MIN(IF(B1:B4="Apple", A1:A4))

Result:

Copy

5

Example 5: MIN with Dates

Data:

Copy

A1: 01/01/2023
A2: 02/01/2023
A3: 03/01/2023
A4: 04/01/2023

Formula:

excel

Copy

=MIN(A1:A4)

Result:

Copy

01/01/2023

Example 6: MIN with Text and Numbers (Ignoring Text)

Data:

Copy

A1: 10
A2: "Apple"
A3: 5
A4: "Banana"

Formula:

excel

Copy

=MIN(A1:A4)

Result:

Copy

5

Example 7: MIN with Empty Cells

Data:

Copy

A1: 10
A2: 
A3: 5
A4: 15

Formula:

excel

Copy

=MIN(A1:A4)

Result:

Copy

5

Example 8: MIN with Negative Numbers

Data:

Copy

A1: -10
A2: -20
A3: -5
A4: -15

Formula:

excel

Copy

=MIN(A1:A4)

Result:

Copy

-20

Example 9: MIN with Multiple Ranges

Data:

Copy

A1: 10  | B1: 20
A2: 5   | B2: 15
A3: 8   | B3: 25
A4: 12  | B4: 18

Formula:

excel

Copy

=MIN(A1:A4, B1:B4)

Result:

Copy

5

Example 10: MIN with Nested Functions

Data:

Copy

A1: 10  | B1: 20
A2: 5   | B2: 15
A3: 8   | B3: 25
A4: 12  | B4: 18

Formula:

excel

Copy

=MIN(A1:A4, MAX(B1:B4))

Result:

Copy

5

Explanation:

• Example 1: Basic usage of MIN to find the smallest number in a range.

• Example 2: Using MIN with non-adjacent cells.

• Example 3: Using MINIFS to find the minimum value based on a condition.

• Example 4: Using an array formula to find the minimum value based on a logical condition.

• Example 5: Using MIN with dates to find the earliest date.

• Example 6: Using MIN with a range that includes text (text is ignored).

• Example 7: Using MIN with a range that includes empty cells (empty cells are ignored).

• Example 8: Using MIN with negative numbers.

• Example 9: Using MIN with multiple ranges.

• Example 10: Using MIN with nested functions like MAX.

These examples demonstrate the versatility of the MIN function in Excel and how it can be combined with other functions to perform more complex calculations.