In this article:

Find the Max Value in Google Sheets (Easiest Way in 2024)

May 8, 2024

How to Find the Max Value in Google Sheets

To find the maximum value in Google Sheets, you can use the MAX function by typing =MAX(range) into a cell, where the range is the group of cells you want to find the maximum value in. Here's how to do it:

Step 1: Select the Cell for the Result

Click on the cell where you want the result of the maximum value to appear. This is where the formula will go.

Step 2: Enter the MAX Formula

Type in the MAX function to find the maximum value. The basic syntax of the MAX function is as follows:


The range is the group of cells you're looking to find the maximum value in. It can be a single column, a row, or a more complex group of cells.

google sheets max value

Step 3: Specify Your Range

After typing =MAX, you need to specify the range of cells. For example, if you're looking for the maximum value in cells A1 through A10, you would enter:


max value google sheets

Below is the result:

find max value google sheets

You can find the maximum value over multiple ranges by separating them with commas inside the function, like =MAX(A1:A10, C1:C10).

google sheets find max value

This is the result: 

find maximum value in google sheets

You can also include individual numbers as part of the range directly in the formula to compare the cell values with these numbers, like =MAX(A1:A10, 5, 20).

find max value in google sheets

The output is as follows:

max value in google sheets

We hope that this article has helped you and given you a better understanding of how to find the max value in Google Sheets! If you enjoyed this article, you might also like our articles on how to find the second highest value in Google Sheets and how to use the CAGR formula in Google Sheets.

Get Google Sheets productivity and automation tips delivered straight to your inbox
Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.
We'll email you 1-3 times a week — and never share your information.
Get your copy of our free Google Sheets automation guide!
  • 27 pages of Google Sheets tips and tricks to save time
  • Covers pivot tables and other advanced topics
  • 100% free

Work less, automate more!

Use Lido to connect your spreadsheets to email, Slack, calendars, and more to automate data transfers and eliminate manual copying and pasting. View all use cases ->