Excel Functions: MAX and MIN Function in Excel

Hello, all, we have covered most of the widely used functions in Excel so far and Today, we will be discussing MAX and MIN Functions of Excel.MAX and MIN functions are widely used for finding out the maximum or minimum value from a set of given numbers. After going through this article, you would be able to implement MAX and MIN Functions in your tables.

Image result for MAX and MIN Function in Excel

What is MAX Function in Excel?

MAX Function in excel helps us in finding out the max or largest value from a given range of values, MAX Function ignores all the values except numerical value.It ignores Logical values, text values, and empty cells as well.

How to use MAX Function in Excel?

A syntax of MAX Function:

=MAX( number_1, [number_2, … number_n] )

ARGUMENTS:

  • number_1: It is a mandatory parameter of MAX Function, It can be defined as a range of number, array, reference to the number, or individually a number.
  • [number_2,……number_n]: It is an optional argument of MAX Function, that can have up to 30 numbers, and using MAX Function one can find out the maximum value from the set of numeric values.

Let’s do an example to understand how can you practically use MAX Function in Excel Sheet.

Consider the Spread Sheet given below,

MAX function

Writing MAX Function:

Here, we have written MAX Function, and we got the maximum value from the list of Qty.Let’s try to write MAX Function Step by step,

  • number_1: As stated above, we can also define a range of numbers or cells here, to find out the maximum value from that range. In the example above, we have specified range of cells as H2: H17, like this,

=MAX( H2: H17)

As we need to find out the maximum value from the range of cells of “Qty” , that is why we have defined H2: H17.

What is MIN Function in Excel?

MIN Function in excel helps us in finding out the min or smallest value from a given range of values, MIN Function ignores all the values except numerical value.It ignores Logical values, text values, and empty cells as well.

How to use MIN Function in Excel?

Syntax of MIN Function:

=MIN( number_1, [number_2, … number_n] )

ARGUMENTS:

  • number_1: It is a mandatory parameter of MAX Function, It can be defined as a range of number, array, reference to the number, or individually a number.
  • [number_2,……number_n]: It is an optional argument of MAX Function, that can have up to 30 numbers, and using MAX Function one can find out the maximum value from the set of numeric values.

Let’s do an example to understand how can you practically use MIN Function in Excel Sheet.

Consider the Spread Sheet given below,

MIN function

Writing MIN Function:

Here, we have written MIN Function, and we got the minimum value from the list of Qty.Let’s try to write MIN Function Step by step,

  • number_1: As stated above, we can also define a range of numbers or cells here, to find out the minimum value from that range. In the example above, we have specified range of cells as H2: H17, like this,

=MIN( H2: H17)

As we need to find out the minimum value from the range of cells of “Qty” , that is why we have defined H2: H17.

So, this is How you can use MAX and MIN Function. We hope you understood the concept.If you think this article was helpful to you, kindly share it with your friends and colleagues who are dealing with problems in understanding Excel Concepts.You can share it on Facebook, Twitter, Instagram or any other social platforms and can help others as well.You can also write your queries to us, we would try our best to help you as soon as possible.

Add a Comment

Your email address will not be published. Required fields are marked *