EXCEL FUNCTION – MIN
Excel Function MIN
MIN function is used to get the smallest number in range or list of values.
Applying the MIN function formula =MIN( give you the minimum value among the Selected cell range.
MIN Formula in Excel
Below is the MIN formula in Excel.
Syntax:
=MIN(number1,[number2],...)
Syntax Description:
number1 argument is required argument where we can give range or value
[number2] argument is optional argument where we can give another range or value
… refers that, we can add multiple range or values by separating them with comma ( , )
How to Use MIN Function in Excel?
The MIN function in Excel is very easy to use. Let us understand the working of the MIN function in some examples.
Example 1:
- Will calculate the lowest marks of students by using MIN formula.
As we can see by applying the formula we got the Minimum score. The result is 25.
EXAMPLE 2:-
The Excel function ignores empty value cells and result is 25. But MINA Value will be 1 as shown above.
EXAMPLE 3:-
if we provide a logical value, the function will ignore it and will give the same result, but MINA will consider it, as shown above:
Things to Remember:
– Function will only consider numeric values while evaluating the smallest value
– Multiple ranges can be applied in function by separating them with a comma (,)
– Text/ Spaces will be ignored by the function
– If No values in the range or list of values (i.e. number argument) then the output will return as 0 (zero)
Hope you learned this Function,
Don’t forget to leave your valuable comments!
