MAX

The MAX function in Google Sheets is an essential tool for extracting the highest value from a given set of numbers. Whether you're analyzing peak sales data, the top-performing student, or the highest daily expenses, the MAX function is your go-to. Delve into our detailed guide to understand its full potential.

Parameters

• value1: The first value or range to consider for the maximum.
• value2, ...: [Optional] Additional numbers or ranges to consider.

Step-by-Step Tutorial

1. Using MAX with individual numbers:

   • Example: =MAX(3, 10, 5)
   • Result: 10

2. Using MAX with a range of cells:

   • Example: If A1:A5 has the values 5, 10, 3, 8, 7, then =MAX(A1:A5) will return 10.

Working with a Single Value, a List, and a Range

MAX accepts numbers one at a time, as a comma-separated list, or as a range — mix and match freely.

• Single value: =MAX(A1) — just returns the value in A1.
• List of values: =MAX(A1, A2, A3) — if A1, A2, A3 are 3, 10, 5, this returns 10.
• Range: =MAX(A1:A10) — returns the largest value in the range.
• Mixed: =MAX(A1, A3:A6, 10) — you can combine single cells, ranges, and literal numbers in one call.

Video Example

Use Cases and Scenarios

1. Financial Analysis: Identify the day with the highest stock market value.
2. Sales Tracking: Determine the product with the highest sales figure.
3. Sports Statistics: Identify the highest score in a basketball game.

Related Functions

• MIN: Find the smallest value in a set.
• MAXA: Similar to MAX, but also evaluates text and other non-numeric data types.

Related Articles

• Top 4 Basic Arithmetic Functions Every Google Sheets User Should Know
• 10 Essential Google Sheets Formulas Every User Should Know