EXCEL MIN FUNCTION

The MIN is an Excel function to find the lowest value in a range or an array.

Syntax:

=min(number1,[number2],[number3],,)

Arguments or Parameters:

number1: first range to find min value.
number2 [optional]: second range to find min value.

Objective: Find the Lowest value of Quantity in cell D3.

Step 1:

Type = sign in cell D3.
Type MIN Function.

Step 2:

Select range B3:B9.
Type “)”.
Press Enter.

Conclusion: The Min function has provided the minimum value of the quantity in cell D3.