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
Double Quotes
whisperer wrote on November 29, 2006 04:36 EST
Hi Rubin,
I felt that I had to pass comment about the use of double quotes in your last tip as they will throw up an error. The minimal/maximal formula should be expressed thus:
Double Quotes
whisperer wrote on November 29, 2006 04:40 EST
Hi Rubin,
I felt that I had to pass comment about the use of double quotes in your last tip as they will throw up an error. The web site version above, although different, still throws up an error.
The minimal/maximal formula should be expressed thus:
Terms
and Conditions of use
The applications/code on this site are distributed as is and without warranties
or liability. In no event shall the owner of the copyrights, or the authors
of the applications/code be liable for any loss of profit, any problems
or any damage resulting from the use or evaluation of the applications/code.
The Intelligent Investor: The Classic Bestseller on Value Investing
