The MAX function
Returns the largest number. Text and blank cells in a range are ignored.
Syntax
MAX(number1, [number2], ...)- number1
- The first number, cell or range.
- number2 (optional)
- More numbers or ranges.
Examples
E1=MAX(C2:C6)
| A | B | C | D | E | |
|---|---|---|---|---|---|
| 1 | Region | Product | Sales | 500 | |
| 2 | North | Shoes | 500 | ||
| 3 | South | Shoes | 300 | ||
| 4 | North | Bags | 250 | ||
| 5 | North | Shoes | 420 | ||
| 6 | South | Bags | 180 |
E1
=MAX(1C2:C6,2600)| A | B | C | D | E | |
|---|---|---|---|---|---|
| 1 | Region | Product | Sales | 600 | |
| 2 | North | Shoes | 500 | ||
| 3 | South | Shoes | 300 | ||
| 4 | North | Bags | 250 | ||
| 5 | North | Shoes | 420 | ||
| 6 | South | Bags | 180 |
In plain words: The largest of 1the sales in C2:C6 and 2600.