MAX

Beginner

Statistical

Returns the largest value in a set of numbers. Ignores text and logical values.

Syntax
=MAX(number1, [number2], ...)
Parameters
number1
Required
(number | range)

First number or range

number2(number | range)

Additional numbers or ranges (optional)

Examples
Real-world examples to help you understand how to use MAX

Find maximum value

=MAX(A1:A10)

Returns the largest number in the range

Result: Maximum value

Max across columns

=MAX(A1:A10, C1:C10)

Finds the largest value across both ranges

Result: Overall maximum

Max with constants

=MAX(A1:A10, 100)

Compares range values with 100

Result: Max of values or 100

Common Use Cases
  • ✓Find highest sales figure
  • ✓Identify peak temperature
  • ✓Track maximum score
  • ✓Find highest price
  • ✓Determine ceiling values
Pro Tips
  • 💡MAX ignores empty cells and text
  • 💡Use MAXA to include logical values
  • 💡Combine with IF for conditional max
  • 💡MAXIFS for max with multiple criteria
Common Errors
  • ⚠️Including text values (they're ignored)
  • ⚠️Not handling empty ranges
  • ⚠️Confusion between MAX and LARGE
Related Formulas
MINLARGEMAXAMAXIFS

Need a Custom MAX Formula?

Our AI can generate tailored formulas based on your specific needs

Generate Custom Formula