Author: Sarthak Bhalerao
Table of Contents
- What is the Max function in Excel?
- How does the Max function work?
What is the Max Function in Excel?
The Max function is categorized under Excel Statistical function. MAX will return the largest value in a given list of arguments. In financial analysis, the MAX function can be very useful in calculating the highest score, the fastest time, or highest revenue or expense, etc. It can be used as a worksheet function (WS) in Excel. As a worksheet function, the MAX function can be entered as part of a formula in a cell of a worksheet.
How does the Max function work?
MAX( number1, [number2, …… number_n])
- Number1 – IT can be a number, named range, array, or a reference number
- Number2 – These are numeric values that can be numbers, named ranges, arrays, or references to numbers. Maximum values are 30. This is optional.
The MAX function returns a numeric value
- Applies to:
Excel for Office 365, Excel 2019, Excel 2016, Excel 2013, Excel 2011 for Mac, Excel 2010, Excel 2007, Excel 2003, Excel XP, Excel 2000