Excel MIN() Function
Excel MIN() Function
The MIN() function in excel returns the smallest or minimum value from the provided numbers, named range or array. It ignores logical values and text.
Syntax
MIN(Number1,Number2, ...)
Parameter
Number1(required)- This parameter represents the string for which you want to find the length.
Number2, …(optional)- It represents the list of values from which you want to find the average value.
Category
Statistical
Returns
This function returns the smallest number in each set of values.
Example 1
Objective: Use MIN function to find the smallest value of the 3 numbers present for each row
Number1 | Number2 | Number3 | Result | Formula |
33 | 54 | 13 | 13 | =MIN(A15:C15) |
19 | A | 10 | 10 | =MIN(A16:C16) |
81 | B | c | 81 | =MIN(A17:C17) |
-8.5 | 3 | -10.5 | -10.5 | =MIN(A18:C18) |
Example 2
Emp_ID | Employee Name | DOJ | Age | Department | Salary |
EMP-001 | Beena Singh | 21-Mar-16 | 21 | Engineer | $95,000 |
EMP-002 | Ritu Sisodia | 27-Feb-16 | 39 | Sales Executive | $150,000 |
EMP-003 | Gajni Seth | 11-Jan-16 | 27 | Engineer | $115,550 |
EMP-004 | Ram nath Kovind | 16-Feb-16 | 45 | Engineer | $99,500 |
EMP-005 | Govind | 31-Mar-15 | 32 | Customer Support Executive | $35,000 |
Objective: What is the age of the youngest employee as per the data?
Result | Formula |
21 | =MIN(A2:F5) |