Excel Max Function – Largest Value

The Excel MAX (Maximum) function will identify the largest or maximum number in a range of cells.

Select the cell where in you want the formula to be entered. (Cell B14)

Next Click on the Sigma  ∑ sign.  The drop down menu will give you a choice of functions – select Max.

The formula =Max(number1,[number2]….etc, Select range of cells, hit Enter Key.

Or type the formula =MAX(B2:B13)  in the example shown below.

Excel07 Max

Advertisements
Explore posts in the same categories: Excel - Helpful Hints & Tips

Tags: , , , , , , , , , , , , , , , , , , ,

You can comment below, or link to this permanent URL from your own site.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s


%d bloggers like this: