MAX function in Excel

Syntax

=MAX(number1, [number2], …)

Example

=MAX(B2:B6) is the top score. =LARGE(B2:B6,2) is the second-highest.

From the lesson MIN, MAX, LARGE, SMALL Functions.

Common mistakes

• Asking for k larger than the number of values (#NUM!).
• Mixing up LARGE and SMALL: LARGE(…,1) equals MAX.

Related statistical functions

• COUNTCounts cells that contain numbers.
• COUNTACounts cells that are not empty.
• COUNTBLANKCounts empty cells in a range.
• COUNTIFCounts cells that meet one condition.
• COUNTIFSCounts cells that meet several conditions.
• AVERAGEReturns the arithmetic mean.
• AVERAGEIFAverages cells that meet a condition.
• MINReturns the smallest value.