Return the largest value in a range.
This function works the same in Google Sheets as it does in Excel — same syntax and arguments.
MAX(number1, [number2], …)MAX returns the highest number in the values you supply, ignoring text and blanks. Pair with MAXIFS for a conditional maximum.
=MAX(C2:C100)Result: $9,800
Highest value in the range.
Use MAXIFS(max_range, criteria_range, criteria) in Excel 2019+.