.png)
Let's look at some Excel Max function examples and explore how to use the Max function as a worksheet function in Microsoft Excel:
Summary
The Excel MIN function returns the smallest numeric value from the numbers provided. This function helps us to locate what the minimum data is located in the spreadsheet or selected range.
The MIN function is a built-in function in Excel that is categorized as a Statistical Function. It function ignores empty cells, the logical values TRUE and FALSE, and text values.
In financial analysis, MIN can be useful in calculating the lowest score, the Minimum time, the lowest expense or revenue amount, minimum salary of the employee, etc.
The MIN function is a built-in function in Excel that is categorized as a Statistical Function. It function ignores empty cells, the logical values TRUE and FALSE, and text values.
In financial analysis, MIN can be useful in calculating the lowest score, the Minimum time, the lowest expense or revenue amount, minimum salary of the employee, etc.
Purpose
Get the smallest value.
Return value
The smallest value in the array.
What Does It Do ?
- This function helps us to locate what the minimum data is located in the spreadsheet or selected range.
- It can be used either horizontally or vertically.
- The numbers can be in single cells, ranges are from other functions.
Syntax
Min function has two syntax and hence they can be written in two different ways:
=MIN(Num1,Num2,...) or
=MIN(Range1,Range2,Range3... through to Range30)
=MIN(Num1,Num2,...) or
=MIN(Range1,Range2,Range3... through to Range30)
Parameters or Arguments
Num: A numeric value or reference.
Range: A group of cells.
Range: A group of cells.
Formatting
No special formatting is needed.
Usage notes
The MIN function can be used to return the smallest value from a set of data. For example, the fastest time in a race, the lowest temperature, or the smallest sales number. Arguments can be provided as constants, or as cell references or ranges, for example:
=MIN(A1:A10)
=MIN(C5,C6,C7)
=MIN(5,10,15,20)
=MIN(C5,C6,C7)
=MIN(5,10,15,20)
Notes:
- The MIN function ignores empty cells.
- The MIN function in current versions of Excel accepts up to 255 arguments. If arguments contain no numbers, MIN returns 0.
- Arguments can be provided as numbers, names, arrays, or references that contain numbers.
- The MIN function ignores TRUE and FALSE values, and numbers entered as text, unless they are typed directly into the list of arguments.
- MIN function through #VALUE! Error if any of the supplied values are non-numeric.
- If MIN function does not have any arguments than it will return the 0 as output.
- Empty cells, logical values, or text in the array are ignored.
Excel Min Function Examples
The following spreadsheet shows three simple examples of the Excel Min function:
The above examples show that each argument to the Min function can be supplied as a single value or cell reference, or as an array of values or cells.
