The MAX function returns the largest value in a set of numbers.
It can be useful for data analysis, for example, when working with financial reports, statistics, and other tasks where it is necessary to determine the maximum value.
Syntax
MAX(value1, [value2, ...])
Argument |
Description |
Permitted values |
|---|---|---|
value1 |
First value or range to consider when calculating the maximum value |
Any numerical values, ranges of cells with numbers. Text values or empty cells without numbers are not allowed |
[value2, ...] |
(optional) Additional values or ranges |
Similar to the first argument |
Examples of use
Search for the maximum value in the range
If you have a data set in cells A1:A10 and you want to find the maximum value:
=MAX(A1:A10)
This formula will return the largest value from the specified range.
Searching for the maximum among several numbers
=MAX(10, 20, 5, 30, 15)
Result: 30, as this is the largest number.
Combining ranges and individual values
You can also combine ranges and individual values:
=MAX(A1:A10, 25, B1:B5)
The result will be the maximum value among all numbers in ranges A1:A10 and B1:B5, as well as the number 25.
Notes
The function ignores text values and empty cells in the specified ranges.