Excel Function - MAX
MAX function is used to get the largest number in range or list of values.
MAX function has one required argument i.e. number1 and optional argument i.e. [number2]…
Syntax:
=MAX(number1,[number2],...)
Syntax Description:
number1 argument is required argument where we can give range or value
[number2] argument is optional argument where we can give another range or value
How to make a MAX formula in Excel
How to Use MAX Function in Excel?
1. Select your cell
Decide where you want the maximum value to appear on your spreadsheet. This might be at the bottom of your data set, to the right or in any open cell. Click into the cell to select it.
2. Open the “Sum” menu
Navigate to the “Home” tab on the ribbon. On the far right, you might see the sum symbol, which looks like a sigma. If you click the arrow to the right of the icon, it prompts a drop-down menu to open. Select “Max”.
3. Input your arguments
The max function formula typically appears in the cell. You can then tell Excel which cell, array of cells or number to evaluate. You can do this by selecting a cell or range of cells or by manually typing in the arguments. You can then press “Enter”, prompting Excel to return the highest value.
Excel Function Max - Usage Notes:-
The MAX function returns the largest numeric value in the data provided. The MAX function can be used to return the largest value from any type of numeric data. For example, MAX can return the slowest time in a race, the latest date, the largest percentage, the highest temperature, or the top sales number.
The MAX function takes multiple arguments in the form number1, number2, number3, etc. up to 255 total. Arguments can be a hardcoded constant, a cell reference, or a range, in any combination. MAX ignores empty cells, text values, and the logical values TRUE and FALSE.
Excel function Max - Examples
The MAX function returns the largest numeric value in supplied data:
=MAX(12,17,25,11,23) // returns 25
MAX ignores logical values and numbers entered as text, unless they are provided as arguments:
Things to Remember:
– Function will only consider numeric values while evaluating largest value
– Multiple ranges can be applied in function by separating them with comma (,)
– Text/ Spaces will be ignored by the function
– If No values in range or list of values (i.e. number argument) then output will return as 0 (zero)
Hope you learnt this Function,
Don’t forget to leave your valuable comments!
If you liked this article and want to learn more similar tricks, please Subscribe to us or follow us on Social Media by clicking the below buttons
Recommended Articles
Excel VBA Course : Beginners to Advanced
We are offering Excel VBA Course for Beginners to Experts at discounted prices. The courses includes On Demand Videos, Practice Assignments, Q&A Support from our Experts. Also after successfully completion of the certification, will share the success with Certificate of Completion
This course is going to help you to excel your skills in Excel VBA with our real time case studies.
Lets get connected and start learning now. Click here to Enroll.
Secrets of Excel Data Visualization: Beginners to Advanced Course
Here is another best rated Excel Charts and Graph Course from ExcelSirJi. This courses also includes On Demand Videos, Practice Assignments, Q&A Support from our Experts.
This Course will enable you to become Excel Data Visualization Expert as it consists many charts preparation method which you will not find over the internet.
So Enroll now to become expert in Excel Data Visualization. Click here to Enroll.
Use Automated Excel Utility Tools to increase productivity
- Quickly Move or Delete Files or Folder >> Click here
- Handle Duplicate Files with Automated Utlity >> Click here
- Generate Dummy Data For Testing >> Click here
- Excel Files and Sheets Consolidator >> Click here
- Manage Outlook Emails efficiently >> CLick here
- Send Bulk Emails wiht our Excel Automation >> Click here
Hope you are enjoying learning Excel with us, if you want any support related to this article, please do comment else you can ask questions in Excel Community
