» Indicators for the maximal and minimal values

Problem:

Creating a formula that will indicate the maximum and minimum values in List1
by returning ""Max Value"" or ""Min Value"" in the cell next to them.

Solution:

Enter the following IF statement, using the MAX and MIN functions, in column B:
=IF(A2=MAX($A$2:$A$8),""Max Value"",IF(A2=MIN($A$2:$A$8),""Min Value"",""""))

List1____Formula
2
40______Max Value
12
4
7
0_______Min Value
30
Screenshot // Indicators for the maximal and minimal values