How can I return the maximum or minimum value! (max min)

We can do this in excel with two different formulas:

  • MAX: return the maximum value in a set of values
  • MIN: returns the minimum value in a set of values

Syntax

=MAX(from_this_range)
=MIN(from_this_range)

Example

Let’s use an example to illustrate the formula. We want to return our maximum value 5 with our MAX formula and we want to return our minimum value 1 with our MIN formula (the black cells).

The Steps

Maximum

from_this_range : Our range of values 1 to 5 (number 1)

=MAX(1 to 5)

Max Result

formula

=MAX(B3:B7)

output

And there you have it, 5 is our maximum value!

Minimum

from_this_range : Our range of values 1-5 (number 1) 

=MIN(1 to 5)

Min Result

formula

=MIN(B3:B7)

output

And there you have it, 1 is our minimum value!

Try making the formula more readable by naming ranges