I have a column of price data. I want to identify which cell has max value
and set a text "max" for indication.

Col A Col B
10
3
6
2
12 max

I only know the max(A$1:A$5), but not know how to set text with it. Please
help.

skysusan

Hi!

If just want the MAX value identified, enter this formula in B1:

=IF(A1=MAX(A$1:A$5),"max","")

Copy down to B5.

If you want to identify BOTH the MAX and MIN, enter this formula in B1:

=IF(A1=MAX(A$1:A$5),"max",IF(A1=MIN(A$1:A$5),"min" ,""))

Note: if the value is both MAX and MIN at the same time the formula will
return "max".

Biff

"skysusan" wrote in message
...
I have a column of price data. I want to identify which cell has max value
and set a text "max" for indication.

Col A Col B
10
3
6
2
12 max

I only know the max(A$1:A$5), but not know how to set text with it. Please
help.

skysusan