Exceljet

Quick, clean, and to the point

Excel MAX Function

Excel MAX function
Purpose 
Get the largest value
Return value 
The largest value in the array.
Syntax 
=MAX (array)
Arguments 
  • array - The array from which you want to select the largest value.
Usage notes 

The MAX function is useful when you want to retrieve the largest value from a set of data. For example, the highest score in a test.

array can be an array constant or a range of cells.

Excel Formula Training

Learn Excel formulas and functions with concise, clear videos. Master absolute/relative addresses, dates, text, named ranges, and tools for troubleshooting. Each video comes with a practice worksheet and audio transcript. Instant access and complete 100% guarantee. Start today!

See details.

Thank You So much...You changed my life :) - Anil
Excel foundational video course
Excel Pivot Table video training course
Excel conditional formatting video course
Excel formulas and functions video training course
Excel Shortcuts Video Course