MAX Function in Excel: Syntax, Examples and Free Practice
MAX is an Excel Statistical function. Returns the largest number in a set.
MAX syntax
=MAX(number1, [number2], ...)
Arguments
number1: The first number or rangenumber2: An additional number or range (optional)
When to use MAX
MAX is used in data analysis work to summarize or test patterns across a data set.
Practice MAX online, free
Open the live Excel-style spreadsheet and try MAX yourself. No Excel install or sign-up needed to start.
Practice MAX now →Watch: MAX in Excel
Learn more
Read the tutorial: MAX, MIN, MEDIAN and MODE.
MAX practice questions
- A sales team's monthly sales are in B2:B8. Find the highest sale. Put it in D2.
- The daily temperature (in °C) for a week is in B2:B8. What was the hottest day's…
- Q1 sales are in B2:B6 and Q2 sales are in C2:C6. Find the single highest figure across…
- Exam marks are in B2:B8. Two students were Absent (typed as text). Find the top mark.…
- A shop made a loss every month (B2:B7 show profit as negative numbers). Find the best…
- Invoice dates are stored as date numbers in B2:B6. Find the date number of the latest…
- Using the sales in B2:B8, show Meera's sales (B4) as a fraction of the best sale. Round…
- January sales are in B2:B7 and February sales in C2:C7. Find the biggest increase from…
- Daily sales for one week are in B2:B8. Find the highest sales figure of the week. Put it…
More Statistical functions
Frequently asked questions
What does the MAX function do in Excel?
Returns the largest number in a set.
What is the syntax of MAX in Excel?
The syntax is =MAX(number1, [number2], ...). number1: The first number or range; number2: An additional number or range (optional).
Where can I practice MAX online for free?
Open the free live spreadsheet on Cellgrids and try MAX yourself. No Excel install is needed and you can start without signing up.
All Excel formulas · Cheat sheet · Excel exercises · Statistical functions · Excel case studies · Excel tutorials · Excel shortcuts