MIN function is used to get the smallest number in range or list of values.
Below is the MIN formula in Excel.
=MIN(number1,[number2],...)
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 ( , )
The MIN function in Excel is very easy to use. Let us understand the working of the MIN function in some examples.
As we can see by applying the formula we got the Minimum score. The result is 25.
The Excel function ignores empty value cells and result is 25. But MINA Value will be 1 as shown above.
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:
– 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!
Understand how to find median in Excel with simple steps. Understanding the middle value in a set of numbers, known as the median, is important in the data industry. Professionals often use Microsoft Excel to calculate this. Excel’s MEDIAN function helps quickly find this value from long lists of numbers. This saves time and allows for further calculations using the median value. In this article, we explain what the MEDIAN function in Excel does, why it’s useful, and two methods to find the median in your data.
Print Row Header on Each Page in Excel means that when you print your worksheet, the selected row (often the top row with column headers) will repeat at the top of every printed page. This ensures…
How to count words in Excel using the LEN function along with other Excel functions. It also gives formulas for counting words or text, whether case-sensitive or not, in a cell or range.
The only thing worse than wrong data in your spreadsheet is Empty Cells. If these blanks aren’t filled, they can cause problems when using formulas. I usually fill these empty cells with 0 or “NA”…
COLUMN function is used to get the column reference number of the excel worksheet. COLUMN Function has only one argument.
SUMPRODUCT function performs multiplication of numbers within arrays and then sum the values SUMPRODUCT function has array1, 2.. arguments.