I have an if statement for a column of rank numbers which will show the text "LOW" when the rank is 1. Is there a way to state an if statement (and add to the current statement) to have it show the text "HIGH" when the largest rank number is listed (instead of referring to a specific number)?
Hope that made sense.

Mike