Better Sheets

How to Use MAX() in Google Sheets

Description

Returns the maximum value in a numeric dataset.

How To Actually Use MAX() in Sheets

MAX(value1, [value2, ...])

Try MAX yourself

Use the MAX() function to find the highest value in the range B1:B10. Your formula should return that maximum value.

Your formula

Hints (2)

Locale Separator ,

Official Docs

Better Sheets Tutorial

Make Color Changing Progress Bars - Make Progress Bars with Sparkline: Part 4

Create awesome progress bars with sparkline formula. You can make progress bar colors can change based on the input.

Intermediate

COUNTIF() MAX() SPARKLINE() TRUE()

Use Min and Max for More Average Averages

What happens very often is we want to figure out an average averages, help us tell the story of a large set of data, but averages also can lie.

Beginner

AVERAGE() MAX() MEDIAN() MIN()

Use Index Match when you want Vlookup

If you find Vlookup a difficult formula to understand, this formula combination might be better. It's also much more flexible than Vlookup. Index/Match is the best. It's one of my favorite formula combinations.

Intermediate

INDEX() MATCH() MAX() VLOOKUP()

Create a Summary Tab with Min and Max

Free tutorial for finding Minimum and Maximum data points.

Intermediate

INDEX() MAX() MIN()

How to Iterate Counting Blank Cells in Google Sheets

Count different types of blank cells. Cells with nothing in them.

Intermediate

ARRAYFORMULA() IF() ISBLANK() MAX()

Better Domain Portfolio Template

Create a better list of domains.

Intermediate

COUNTA() FILTER() INDEX() MATCH() MAX() +1 more

Transcript-matched member videos for MAX(). Click through to watch.

Watch more tutorials

Write Apps Script to Create a New Google Sheets Formula

Create a brand new custom formula in Apps Script. We'll do this for our ...

Hardest Formula: SumIF | Addition Based on Dates / Values

Demystifying the SumIF Formula. Add up your values based on a condition,...

SUMIF() UNIQUE()

Google Sheet Basics - The Absolute Basics

Let's start at the basics of Google Sheets. Where every beginner spreads...

Beginner

Learn Google Sheet Formulas The Hard Way

One weird way to learn more about what Google Sheets can do. https://bet...

Unlock these tutorials

Learn more about the MAX() formula:

Generate a MAX() formula for your needs

Describe your task in plain English and get a paste-ready formula that uses MAX(). 2 free AI generations, no signup. Members get unlimited use.

Generate a MAX() formula

How to Use MAX() in Google Sheets

Try MAX yourself

Make Color Changing Progress Bars - Make Progress Bars with Sparkline: Part 4

Use Min and Max for More Average Averages

Use Index Match when you want Vlookup

Create a Summary Tab with Min and Max

How to Iterate Counting Blank Cells in Google Sheets

Better Domain Portfolio Template

More related tutorials

Write Apps Script to Create a New Google Sheets Formula

Hardest Formula: SumIF | Addition Based on Dates / Values

Google Sheet Basics - The Absolute Basics

Learn Google Sheet Formulas The Hard Way