"E
n" is what I used for "E"-plus-row-number, whatever row you happen to be on. (I use R1C1 notation, myself, which would be ideal for this sort of thing if anyone else used it too.) So on row 2 the formula would be
Code:
=IF(E2=MAX(E:E),"High","Something else")
...or in R1C1 it would look like this:
Code:
=IF(RC5=MAX(C5),"High","Something else")
As for the "Something Else",
you have to specify what you want it to display if it's not "Low" or "High". I was being more or less jocular with "Something else"; probably you'll use just a blank string, "".