MAX
Formulas / MAXTo get the largest value in a set of data.
=MAX(number1, [number2], ...)
- number1 - a number, numeric value reference, or range with numeric values.
- number2, ... - additional numbers, numeric value references, or ranges with numeric values. Up to 255 total numerical arguments are accepted by MAX.
Examples
=MAX(12,17,25,11,23) // returns 25=MAX(5,10) // returns 10Note how MAX can take a values as separate arguments in this example and the last example.
=MAX(A1,A2,A3) // returns the maximum in A1, A2, A3=MAX(A1:A10) // returns the maximum in the range A1:A10=MAX(A1:A10,C1:C10) // returns the maximum value in C1:C10 and A1:A10=MAX(-1,TRUE) // returns 1MAX returns 1 in this example because MAX does not ignore logical values that are directly provided as arguments.
=MAX(-1,TRUE,"3") // returns 3In this example, MAX returns 3 because MAX does not ignore numbers in text when directly provided as arguments.
Need help with Formulas?
Summary
The MAX function returns the largest value from a group of values provided as numbers, names, arrays, or references.
- The MAX function returns the largest numeric value from any type of numeric data.
- The MAX function ignores empty cells, text values, and logical values (TRUE and FALSE).
- MAX can take hardcoded constants, cell references, and ranges as arguments.
- MAX can combine different types of arguments together when ti is evaluated.
- Unlike MAX, MAXA calculates max with logical values and numbers in text.
Frequently Asked Questions
What is the MAX function?
The MAX function returns the largest value in a set of numbers. MAX can take up to 255 arguments, but only one is required.
How does MAX work?
MAX finds the largest value in a set and returns it. MAX only uses numbers in arguments that are arrays or references.
What are the limitations of MAX?
MAX returns 0 (zero) if there are no numbers in the arguments. Logical values, text, and empty cells in the arguments are ignored by MAX.
Is there a similar function to MAX?
Yes, the MAXA function is similar to MAX, but it includes logical values and numbers in text in the max calculation.
Work smarter
Al is here to help. Leverage the latest models to
analyze spreadsheets, enrich data, and create reports.
Drop CSV