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)  



ADVERTISEMENT
ADVERTISEMENT