min and max formula

6 Easy ways to Understand the MIN and MAX Excel Formula


To determine the minimum value inside the given range, use the MIN formula. The MAX Formula is used to determine the highest value within the given range.

Syntax :

MIN(number1, [number2], …)

Arguments :

Number1 - Can be a Range, Constant Number
Number2 - Can be a Range, Constant Number

Main Usages :


MAX and MIN Formulas are primarily used to find and values in real time. For example, we can use this to find the minimum and maximum numbers in a large list.

Examples :

Let us see some of the real-time examples we face on MIN and MAX.

Scenario-1 : Finding the Minimum Amount from the Range

The below formula is used to find the minimum value in the range.


Syntax :

=MIN(D6:D15)

Since D6:D15 was used as the range in the aforementioned example, the controller will search for the lowest values that fall within this range. The outcome is 240.

Scanario-2 : Finding the Minimum Amount with Multiple Ranges

Below example is used to find the minimum value with multiple ranges.

Syntax :

=MIN(D6:D8,D11:D13)

In above example we have used 2 different ranges, from those two ranges we are identifying the minimum value. So the result will be 240.

Scanario-3 : Finding the Minimum amount from String Type with Number Type

Below example is used to find the minimum value with multiple data types.

Syntax :

==MIN(B6:B9,D10:D12) 

In the preceding example, we used two different data types; B6:B9 will contain String Data, whereas D10:D12 will contain Numbers, so the controller will look for the minimum value from D10:D12. As a result, the answer is 35000.

Scenario-4 : Finding the maximum Amount from the Range


The below formula is used to find the maximum value in the range.

Syntax :

=MAX(D7:D12)

In above example, we have used the range as D7:D12, so the controller look for the maximum values available in this range. So the Result is 240.

Scanario-5 : Finding the Maximum Amount with Multiple Ranges


Below example is used to find the maximum value with multiple ranges.

Syntax :

=MAX(D6:D8,D14:D15) 

In above example we have used 2 different ranges, from those two ranges we are identifying the maximum value. So the result will be 240.

Scanario-6 : Finding the Maximum number from the String


Below example is used to find the maximum value with different data type.

Syntax :

=MAX(B6:B15) 

In above example we have used different data type, cell B6:B15 will contain String Data. So the result will be 0.

Related Posts

Leave a Reply

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