EDUCBA

EDUCBA

MENUMENU
  • Free Tutorials
  • Certification Courses
  • 120+ Courses All in One Bundle
  • Login
Home Excel Excel Resources Statistical Functions in Excel MAX Excel Function
Secondary Sidebar
Excel Functions
  • Statistical Functions in Excel
    • COUNTIF Formula in Excel
    • COUNTIF Multiple Conditions
    • COUNTIFS with Multiple Criteria
    • Statistics in Excel
    • Confidence Interval in Excel
    • Interpolate in Excel
    • Linear Programming in Excel
    • COUNTIFS in Excel
    • Excel Variance
    • Normal Distribution Formula in Excel
    • Count Cells with Text in Excel
    • Excel Formula For Rank
    • Linear Regression in Excel
    • COUNTA Function in Excel
    • MAX Formula in Excel
    • Excel NORMSINV
    • Count Names in Excel
    • FORECAST Formula in Excel
    • NPER in Excel
    • Excel Median Formula
    • Lognormal Distribution in Excel
    • Excel Chi Square Test
    • Count Formula in Excel
    • COUNTIF Examples in Excel
    • Excel P-Value
    • COUNTIF Not Blank in Excel
    • Excel Standard Deviation Formula
    • Excel GROWTH Formula
    • Excel Percentile Formula
    • Excel Frequency Formula
    • Excel Average Formula
    • Excel Correlation Matrix
    • Excel Z Score
    • Excel MAX IF Function
    • Z TEST in Excel
    • Excel Trendline
    • Excel F-Test
    • Excel STDEV Function
    • Excel Frequency Distribution
    • DCOUNT Function in Excel
    • Excel MIN Function
    • Excel Forecast Function
    • FREQUENCY Excel Function
    • COUNTIF with Multiple Criteria
    • Standard Deviation in Excel
    • MAX Excel Function
    • Excel QUARTILE Function
    • Excel T.Test Function
    • Excel PERCENTILE Function
    • MODE Excel Function
    • SLOPE Excel Function
    • Excel Median Function
    • Excel TREND Function
    • Excel Count Function
    • Excel LARGE Function
    • SMALL Excel Function
    • COUNTIF Excel Function
    • Excel AVERAGE Function
    • Excel CORREL Function
  • Excel Functions (12+)
  • Excel Tools (114+)
  • Financial Functions in Excel (17+)
  • Logical Functions in Excel (14+)
  • Lookup Reference Functions in Excel (35+)
  • Maths Function in Excel (47+)
  • TEXT and String Functions in Excel (26+)
  • Date and Time Function in Excel (24+)
  • Information Functions in Excel (4+)
  • Excel Charts (56+)
  • Excel Tips (222+)
  • Workplace Productivity (4+)
  • Microsoft Office Tools (15+)
  • Excel Formula and Functions (22+)
  • MS Excel Shortcuts (4+)
Excel Functions Courses
  • EXCEL ADVANCED Training Certification
  • Online Excel for Marketing Course

MAX Excel Function

By Pradeep SPradeep S

MAX Function in Excel

Excel MAX Function (Table of Contents)

  • MAX in Excel
  • MAX Formula in Excel
  • How to Use MAX Function in Excel?

MAX in Excel

Max function in excel is the simplest form of a mathematical function, which just returns the maximum values out of the selected values or array. We can selected values one by one, or in one go, we can select a complete range of numbers if available in a sequence. It also neglects the blank cells, logical values, and text if any of these comes in a selected range.

Start Your Free Excel Course

Excel functions, formula, charts, formatting creating excel dashboard & others

All in One Excel VBA Bundle(120+ Courses, 30+ Projects)
Basic ExcelAdvanced ExcelVBA & MacrosExcel Dashboards
Pivot TablesStatistical FunctionsFinancial FunctionsCharts & Graphs
Price
View Courses
120+ Online Courses | 30+ Projects | 500+ Hours | Verifiable Certificates | Lifetime Access
4.9 (64,325 ratings)

MAX Formula in Excel:

Below is the MAX Formula in Excel:

MAX Formula in Excel

The MAX Formula in Excel has the parameter as below :

  • number1, [number2]: The number or cell reference or range arguments can be one or more numeric values from which you want to find the maximum value in Excel.

number1 is a compulsory parameter or argument, whereas the remaining subsequent numbers are an optional argument. From excel 2007 & later versions, it can take up to 255 arguments. The Formula for the ‘MAX’ function is exactly similar or the same as that for the ‘MIN’ function. We can mix literal values along with cell references to find out the maximum value.

e.g. =MAX(D8:D19,100) here literal value in the function is 100.

How to Use MAX Function in Excel?

MAX Function in Excel is very simple and easy to use. Let us understand the working of MAX Function in Excel by some MAX Formula in Excel examples.

You can download this MAX Function Excel Template here – MAX Function Excel Template

MAX Function can be used as a worksheet function and as a VBA function.

Example #1

The below-mentioned table contains a category of items in column C (C8 to C19) & sale value in column D (D8 to D19). I need to find out which category has maximum sales in the supermarket. MAX Function in Excel is used on the range of values representing sales by category to extract the highest value.

Let’s apply Max Function in cell “D20”. Select the cell “D20”, where Max Function needs to be applied.

Find out Highest sales in Supermarket

Click the insert function button (fx) under the formula toolbar; a dialog box will appear, type the keyword “MAX” in the search for a function box; MAX Function will appear in select a function box Double click on MAX Function.

MAX Example 1-2

A dialog box appears where arguments for MAX Function needs to be filled or entered i.e. =MAX(number1, [number2], … )

=MAX(D8: D19) Here, the sales data is present in the range (D8: D19). To enter the Number 1 argument, click inside cell D8 and you’ll see the cell selected, then Select the cells till D19. So that column range will get selected, i.e. D8: D19. Click ok after entering the number1 argument.

MAX Example 1-3

=MAX(D8: D19), i.e. returns the maximum sales value 6679 as a result.

 Result of Example 1

MAX Function has returned the maximum available sales value within a defined range, i.e. 6679 under the utensil’s category.

Example #2

To calculate the maximum or highest score in academics for a specific subject (Mathematics).

The below-mentioned table below contains the student’s Name in column H (H2 to H18) & each student’Fs score (I2 to I18). I need to find out which student has scored a maximum or highest score in mathematics subject. Here, MAX Function in Excel is used on the range of values representing the score to extract the highest value.

Let’s apply Max Function in cell “I19”. Select the cell “I19”, where Max Function needs to be applied.

Find out the Highest Score

Click the insert function button (fx) under the formula toolbar; a dialog box will appear, type the keyword “MAX” in the search for a function box; MAX Function will appear in select a function box. Double click on MAX Function.

MAX Example 2-2

A dialog box appears where arguments for MAX Function needs to be filled or entered i.e. =MAX(number1, [number2], … )

=MAX(I2: I18) Here, the score data is present in the range (I2: I18). To enter the Number 1 argument, click inside cell I2 and you’ll see the cell selected, then Select the cells till I18. So that column range will get selected, i.e.I2: I18. Click ok after entering the number1 argument.

MAX Example 2-3

=MAX(I2: I18), i.e. returns the maximum score value 97 as a result.

Result of Example 2

Here, MAX Function has returned the maximum score value within the defined range, i.e. 97, under the score category.

Example #3

To calculate the maximum or highest Salary for an employee in the company.

The below-mentioned table below contains the Name of the employee in column C (C27 to C43) & the Salary of an employee (D27 to D43). I need to find out which employee is getting the highest or maximum salary in the company. Here, MAX Function in Excel is used on the range of values representing an employee’s salary to extract the highest or maximum value.

Let’s apply Max Function in cell “D44”. Select the cell “D44”, where Max Function needs to be applied.

Find out Highest Salary for Employee

Click the insert function button (fx) under the formula toolbar; a dialog box will appear, type the keyword “MAX” in the search for a function box; MAX Function will appear in select a function box. Double click on MAX Function.

MAX Example 3-2

A dialog box appears where arguments for MAX Function needs to be filled or entered i.e. =MAX(number1, [number2], … )

=MAX(D27: D43) Here, the salary data is present in the range (D27: D43). To enter the Number 1 argument, click inside cell D27 and you’ll see the cell selected, then Select the cells till D43. So that column range will get selected, i.e. D27: D43. Click ok after entering the number1 argument.

MAX Example 3-3

=MAX(D27: D43), i.e. returns the maximum salary of the employee, i.e. 95,916 as a result.

 Result of Example 3

Here, MAX Function has returned the maximum or highest salary of an employee within a defined range, i.e. 95,916.

Things to Remember

  • Argument type can be a cell reference, range reference, column reference row reference, numbers, multiple columns/rows & cell, and range names.
  • Max Function in Excel ignores numbers entered as text values, empty cells & the logical values TRUE and FALSE & it should not have any error value (#N/A, VALUE, DIV).
  • If there are no numbers in a specified range or arguments, it will return 0.
  • If there is an error value in the argument or text, it will return #N/A.
  • MAX Function in Excel is the same as LARGE function; both return the biggest number.
  • #VALUE! error: It Occurs if any non-numeric values are supplied directly to the Max Function.

Recommended Articles

This has been a guide to MAX in Excel. Here we discuss the MAX Formula in Excel and how to use MAX Function in Excel along with practical examples and downloadable excel templates. You can also go through our other suggested articles –

  1. Excel MAX IF Function
  2. Excel SUM MAX MIN AVERAGE
  3. VBA Max
  4. Excel MIN Function
Popular Course in this category
Excel Advanced Training (16 Courses, 23+ Projects)
  16 Online Courses |  23 Hands-on Projects |  140+ Hours |  Verifiable Certificate of Completion
4.8
Price

View Course

Related Courses

Excel for Marketing Training (8 Courses, 13+ Projects)4.9
0 Shares
Share
Tweet
Share
Primary Sidebar
Footer
About Us
  • Blog
  • Who is EDUCBA?
  • Sign Up
  • Live Classes
  • Corporate Training
  • Certificate from Top Institutions
  • Contact Us
  • Verifiable Certificate
  • Reviews
  • Terms and Conditions
  • Privacy Policy
  •  
Apps
  • iPhone & iPad
  • Android
Resources
  • Free Courses
  • Excel Charts
  • Excel Tips
  • All Tutorials
Certification Courses
  • All Courses
  • Excel VBA Course - All in One Bundle
  • VBA Course
  • Excel Data Analysis Course
  • Excel for Marketing Course
  • Excel for Finance Course
  • Excel for HR Training

ISO 10004:2018 & ISO 9001:2015 Certified

© 2022 - EDUCBA. ALL RIGHTS RESERVED. THE CERTIFICATION NAMES ARE THE TRADEMARKS OF THEIR RESPECTIVE OWNERS.

EDUCBA
Free Excel Course

Excel functions, formulas, charts, formatting creating excel dashboard & others

*Please provide your correct email id. Login details for this Free course will be emailed to you

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA Login

Forgot Password?

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA
Free Excel Course

Excel functions, formula, charts, formatting creating excel dashboard & others

*Please provide your correct email id. Login details for this Free course will be emailed to you

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you

By signing up, you agree to our Terms of Use and Privacy Policy.

Let’s Get Started

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA

Download MAX Function Excel Template

EDUCBA

Download MAX Function Excel Template

EDUCBA

डाउनलोड MAX Function Excel Template

This website or its third-party tools use cookies, which are necessary to its functioning and required to achieve the purposes illustrated in the cookie policy. By closing this banner, scrolling this page, clicking a link or continuing to browse otherwise, you agree to our Privacy Policy

Loading . . .
Quiz
Question:

Answer:

Quiz Result
Total QuestionsCorrect AnswersWrong AnswersPercentage

Explore 1000+ varieties of Mock tests View more