When to use Excel MAX Function
MAX function can be used when you want to get the largest value from a set of values.
What it Returns
It returns the largest value from a set of values.
Syntax
=MAX(number1, [number2], …)
Input Arguments
number1 – the first number from a set of values from which you want to get the maximum value. [number2], .. – (optional) second number from a set of values from which you want to get the maximum value. Up to 255 arguments can be used in the MAX function.
Additional Notes
Empty cells, logical values, or text in the array or reference are ignored. Arguments that are error values or text that cannot be translated into numbers cause errors. Arguments can either be numbers or names, arrays, or references that contain numbers. Logical values and text representations of numbers that you type directly into the list of arguments are counted. If an argument is an array or reference, only numbers in that array or reference are used. Empty cells, logical values, or text in the array or reference are ignored. If the arguments contain no numbers, MAX returns 0 (zero).
Excel MAX Function – Live Example
Excel MAX Function – Video Tutorial
Related Excel Functions:
Excel INT Function. Excel MOD Function. Excel RAND Function. Excel RANDBETWEEN Function. Excel ROUND Function. Excel RANK Function. Excel LARGE Function. Excel MIN Function. Excel SMALL Function.