Arrow left
Back to product guides
Google Sheets Formulas

How to Use MAX Function in Google Sheets

In this article, you will learn how to apply the MAX formula in Google Sheets.

How to utilize MAX formula in Google Sheets

  1. Type “=MAX” or go to “Insert” → ”Function” → "MAX“.
  2. Select a range from which you want to find the highest number.

How to insert the MAX function from the menu bar in Google Sheets

The generic formula is as follows:

=MAX(value1, [value2, …])

Value 1: This could be a single number, a cell reference, or a range of cells

Let’s see some examples. Assume your company is preparing for a new product launch and you are working on quality tests for some product types (Type A to F) and want to find the highest score from a list of scores of the quality tests (Test A, B, and C). You can adjust the selection of a range based on the highest number you want to see.

How to use MAX formula in Google Sheets with examples

(i) The highest Total Score

In the first example, the selected range is Total Scores of all types - 21, 24, 27, 30, 33, 36.

(ii) The highest single Test Score (in any Tests) for Type A

In the second case, the selected area contains Type A’s test results in each Test - 1, 7, 13.

(iii) The highest Test A Score

For the third example, Test A scores of all types are selected as a range in the formula - 1, 2, 3, 4, 5, 6.

(iv) The highest single score in Test A and C

You can select non-adjacent fields, as shown in the fourth example. In such a case, each field (as “Value”) should be punctuated by a comma.

(v) The highest single score in all Tests

You can also select an entire area if you want, but you must ensure that the chosen range doesn‘t contain irrelevant figures.

(vi) Example of a manual input

We recommend you always use cell reference(s), but if you want to know how to manually input a series of numbers in a formula to get the highest one among them, see the sixth example. You can input each number (as each “Value”) by punctuating them with commas.

What does the MAX function do in Google Sheets?

It is simple. The function finds the highest number in a selected range.

How do you find the minimum value in Google Sheets?

You can use the MIN function in Google Sheets to find the lowest figure in a selected range.

Analyze your live financial data in a snap

Are you learning this formula to process financial data, build a financial model, or conduct financial analysis? If so, LiveFlow may help you to automate manual workflows and keep numbers updated in real time. For instance, you can easily compare your Budget versus Actual without any manual work. Furthermore, you can access more than fifty templates here, from the simple Income Statement and Operational KPI templates to Multi-Currency Consolidated Income Statement, Balance Sheet, and Cash Flow templates. You can also customize these templates as you want without breaking the automated data inflow.

To learn more about LiveFlow, book a demo.

Automate any custom financial dashboard in Google Sheets with LiveFlow

Learn how to do this step-by-step in the video below 👇

Do you need personal help?

Our team of real people are here to help you any time between 9am and 10pm GMT.
Check Icon
Email us at:
Check Icon
Call us at +1 (415) 650-1711