Menu
EXCEL MIN FUNCTION
Excel MIN Function Introduction
The lowest value from a collection of cells will be returned by this function.
Description of Excel MIN Function
Syntax:
=MIN (number1, [number2], …)
- The first number is required; following numbers are optional. You have a range of 1 to 255 integers for which you want to determine the least value.
Step By Step Guide of MIN Function
In this example, we are obtaining the group’s lowest value, which is =MIN(A2:A8), 54.
Key Points
- Arguments can be integers, characters, arrays, or references containing numbers.
Logical values and text representations of numbers entered directly into the argument list are Recorded. - Only integers in an array or reference are utilized if an argument is an array or reference. In the array or reference, blank cells, logical values, or text are disregarded.
- If there are no numbers in the parameters, MIN returns 0.
Errors are caused by arguments that are error values or language that cannot be converted into numbers.
Related Functions
INDEX Function
INDEX Function
Explore NowMATCH Function
MATCH Function
Explore NowHLOOKUP Function
HLOOKUP Function
Explore NowVLOOKUP Function
VLOOKUP Function
Explore NowDATE Function
DATE Function
Explore NowIF Function
IF Function
Explore NowOR Function
OR Function
Explore NowAND Function
AND Function
Explore NowRANK Function
RANK Function
Explore NowSUMIF Function
SUMIF Function
Explore NowXIRR Function
XIRR Function
Explore NowWORKDAYS Function
WORKDAYS Function
Explore Now
