How can I return the maximum or minimum value! (max min)
We can do this in excel with two different formulas:
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