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)

Related Topics

How to print titles in Excel

In Microsoft Excel, if a particular task is completed in the worksheet, the user wants to print the worksheet. While performing this job, the row and column headings will display...

3 minutes read.

Excel MID() Function

The MID() function in excel is used to return a specific number of characters from a text string starting at the position you specify. One can change the start of the string, thus...

1 minute read.

Excel COUNTBLANK() Function

Excel COUNTBLANK() Function The COUNTBLANK() function in excel counts the number of blank cells within a range. Syntax COUNTBLANK ([value1], [value [2], ...) Parameter value1(required)- This parameter represents the first cell in the range. value2, …(optional)- It represents...

1 minute read.

Excel IFERROR() Function

The IFERROR() function in excel returns the specified value if initially supplied the argument or formula returns an error, otherwise returns the result of the formula supplied in the first argument. When...

2 minutes read.

Excel OR() Function

The OR() function in excel tests the multiple sets of conditions and returns TRUE if any of the arguments are TRUE and FALSE if all the arguments supplied do not meet the...

2 minutes read.

Excel RIGHT() Function

The RIGHT() function in excel returns the rightmost characters from a text value. This function is used for data manipulation. Syntax RIGHT(Text, [num_chars]) Parameter Text (required)- This parameter represents the string from which you want to find...

1 minute read.

Excel IF() Function

Excel IF() Function: The IF() function in excel checks whether a condition is true or not and returns one value if the condition is TRUE and another value if it's...

2 minutes read.

Nearest Multiple in Excel

In Excel, the values in Multiplication can be round up, down and to nearest Multiplication number using Excel default function. This makes the calculation to be performed in an easier...

3 minutes read.

Excel WEEKNUM() Function

The WEEKNUM() function in excel returns the week number from 1 to 54 of a specific date in a year. The WEEKNUM function starts counting with the week that contains January 1...

1 minute read.

Data Validation in Excel

What is Data Validation? Data Validation is one of the features in Excel that allows user to restrict values which other people can fill in – for example, in a form, you may...

4 minutes read.

Excel EDATE() Function

Excel EDATE() Function The EDATE() function in excel returns the serial number of the date that is the indicated number of months before or after the start date. Syntax EDATE(Start_Date, Month) Parameter Start_Date(required)- This parameter represents...

1 minute read.

How to make use of the Wildcard in Excel

In this modern world, it is known that the wildcard characters in Microsoft Excel are considered to be the most essential and unrated features of Microsoft Excel. Besides all these,...

8 minutes read.

Operators in Excel

In MS Excel, operators are used to defining the operation you want to perform on the used elements or between variables. There are four types of operators: Arithmetic operators, Comparison...

4 minutes read.

Excel AVERAGE() Function

Excel AVERAGE() Function The AVERAGE() function returns the average of its arguments, which can be number or names, arrays, or references that contain numbers. It ignores text values and blank cells. Syntax AVERAGE(Number1,Number2, ...) Parameter Number1(required)- This parameter...

1 minute read.

Check Marks in Excel

What is a Check Mark? Among various characters checkmark is one of the characters used to indicate that the item or product in the list is correct, chosen or selected. A...

5 minutes read.

Excel HLOOKUP() Function

Excel HLOOKUP() Function The HLOOKUP() function in excel is used to search a value in the topmost row of a table and then return a corresponding value in the same column for the specified...

2 minutes read.

Adding Column in Excel

Excel spreadsheet is a combination of rows and columns. After creating the table, there is a need to insert additional row or columns. To organize a better worksheet for calculations,...

5 minutes read.

How to apply Data Protection to the Worksheet?

What do we mean by Data Protection? Data Protection in excel involves in protecting your file/data from some other user and also prevents the following accidents – Accidentally deleting or changing the formulas in...

3 minutes read.

Excel Unique Values

The Unique function in Excel filters the list of unique values from the given data like range or array. The data presented is either number, text, date, time etc. This...

3 minutes read.

Excel SECOND() Function

Excel SECOND() Function The SECOND() function in excel converts a serial number to SECOND (0 - 59). Syntax SECOND (SERIAL_NUMBER) Parameter SERIAL_NUMBER (required)- This parameter represents the date or time from which you want to extract...

1 minute read.