MAX Function Explained
The MAX function in Microsoft Excel returns the maximum value from a set of values. It can take up to 255 arguments, which can be numbers, cell references, ranges, arrays, or constants. It ignores logical values and text values. It returns the maximum value from the set of values, or a #VALUE! error if no arguments are provided.
MAX Function Syntax
MAX(number1, [number2], ...)
number1: The first number, cell reference, or range for which you want to find the maximum value.number2: (optional) Additional numbers, cell references, or ranges for which you want to find the maximum value.