# MAX Formula in Excel

What does it do? Get the largest value from a range of values Formula breakdown: =MAX(number1,... read more

## Overview

What does it do?

Get the largest value from a range of values

Formula breakdown:

=MAX(number1, [number2], …)

What it means:

=MAX(a number or range of values, [additional numbers], …)

If you want to get the largest value out of a list of values, just one use of Excel’s MAX Formula gives you the answer instantly!

I explain how you can do this below:

STEP 1: We need to enter the MAX function in a blank cell:

## =MAX(

STEP 2: The MAX arguments:

## number1, [number2], …

Where is the list of values?

Select the cells containing the values that you want to get the maximum value from.

## =MAX(C9:C12)

You now have the maximum value of 100 from the list!

How to Use the MAX Formula in Excel

##### Bryan

Bryan is a best-selling book author of the 101 Excel Series paperback books.

### Get Video Training

Dramatically Reduce Repetition, Stress, and Overtime!
Exponentially Increase Your Chances of a Promotion, Pay Raise or New Job!

Learn in as little as 5 minutes a day or on your schedule.