Returns the maximum value.
= MAX(number1, [number2], …)
- number1: A number, a cell that has a number or a range of cells having numbers from which you want to get the largest number.
- [number2]: A number, a cell that has a number or a range of cells having numbers from which you want to get the largest number.
- You can refer to a single cell, a named range, a range of cells or an array.
- If there are no numbers in specified arguments it will return 0.
- If there is a text or error value in the argument, it will return #N/A.
- If you directly enter a logical value or a text which represents a number into the function, that will be counted.
- It will only consider numeric values. Empty cells, text, and logical values in a reference or an array will be ignored.
- The maximum number of arguments you can refer to is 255.
Written by Puneet for Excel 2007, Excel 2010, Excel 2013, Excel 2016, Excel 2019, Excel for Mac