# MAX

Formulas / MAX
To 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 10`

Note 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 1`

MAX returns 1 in this example because MAX does not ignore logical values that are directly provided as arguments.

• `=MAX(-1,TRUE,"3") // returns 3`

In this example, MAX returns 3 because MAX does not ignore numbers in text when directly provided as arguments.

## 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.