Excel MAX() Function
Excel MAX() Function
The MAX() function in excel returns the largest or maximum number from a range of cells. It ignores logical values and text.
Syntax
MAX(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 largest number in a given set of values.
Example 1
Objective: Use MAX function to find the greatest value of the 3 numbers present for each row
Number1 | Number2 | Number3 | Result | Formula |
33 | 54 | 13 | 54 | =MAX(A15:C15) |
19 | A | 10 | 19 | =MAX(A16:C16) |
81 | B | c | 81 | =MAX(A17:C17) |
-8.5 | 3 | -10.5 | 3 | =MAX(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 oldest employee as per the data?
Result | Formula |
45 | =MAX(A2:F5) |