How To Use Excel MAX Function – Quick Guide

Given a set of data which includes the cricket team scores, you might want to find the highest among them.

Let us see how to use it in detail…

1. What is the MAX Function?
2. What is the Syntax?
3. How to use it with an example?


1. What is the MAX Function?

The MAX function can be used to get the maximum value from a range of values.


2. What is the Syntax?

=MAX(value1,value2,value3…)

  • value1   =  A number, range,expression or a cell reference.
  • value2,value3…  =  Optional, it can be a numbercell reference, expression or range.

Note :

  • If a reference to a cell, or an array of cells are directly supplied to the Max function will ignore blank cells, and text or logical values contained within the supplied cell range.
  • However, the text representations of numbers that are supplied directly to the function will be included in the calculation.
  • I the range provided or cell referencing it contains error then it causes an error.

3. How to use it with an example?

Assuming we have a column with some data in it
Let’s quickly find the MAX of the given range…

=MAX(B3:B7)

Excel Max function

Few other possible operations…

=MAX(B2,B8) // Returns the maximum number from the given references
=MAX(B2,-3,"8",9) // Returns the maximum number from the arguments

 

Advertisements

Author: Sharath Raju

Founder@www.ExcelCult.com

Leave a Reply