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.
