How do I use MAX in Excel?
Use MAX when you want to find the highest value. Enter Target range in that order, then add optional arguments when needed.
Excel Function
MAX
Returns the largest value.
MAX(number1, [number2], ...)Arguments
number1
RequiredSpecify the first number or range to calculate.
Practice Preview
Use MAX to return the maximum value in Sales in column D. You can set ranges by dragging from the start cell to the end cell in the same argument field.
Example Table
| # | AProduct ID | BProduct Name | CCategory | DSales |
|---|---|---|---|---|
| 2 | P001 | Apple | Food | 1200 |
| 3 | P002 | Banana | Food | 980 |
| 4 | P003 | Notebook | Stationery | 450 |
| 5 | P004 | Pen | Stationery | 300 |
| 6 | P005 | Grapes | Food | 1500 |
| 7 | P006 | Ruler | Stationery | 250 |
| 8 | P007 | Peach | Food | 860 |
How to Use (Formula)
=MAX(D2:D8)Result
1500
Practice This Function
MAX FAQ
Where can I practice MAX?
Use the "Start Function Practice" button to jump straight into MAX drills.
What arguments does MAX use?
The main arguments are Target range. Enter them in order.