Statistical
Modern
MAX
Returns the largest number in a range.
Available in All versions
Syntax
MAX(number1, [number2])What it returns
The maximum value.
Arguments
| Argument | Required | Description |
|---|---|---|
number1 |
Yes | The first number or range. |
number2 |
No | Additional numbers or ranges (up to 255). |
Example
| A | |
|---|---|
| 1 | Amount |
| 2 | 10 |
| 3 | 20 |
| 4 | 30 |
| 5 | 40 |
Result
40
MAX returns the largest number in the range (40).
=MAX(B2:B100)Important to know
Ignores text and empty cells.
If the referenced range contains no numbers, returns 0.