Excel FunctionsLesson 94Free preview
MAX
This lesson is part of Excel · All levels
Summary
MAX is an Excel statistical function that returns the largest value of a set of numbers or ranges. The syntax is. Text, logic, and empty cells are ignored so that the result is purely the greatest number.
Key points
- Syntax: MAX(number1, [number2], ...)
- Empty cells and text ignored, not considered zero
- Can accept multiple ranges at once
- The MAXIFS variant calculates the maximum value based on the criteria
Full lesson
Code examples and quizzes
Full lessons, code examples, and quizzes are available to subscribers. 5 questions.