So I have a workbook with a bunch of mean values from 1 to 5, with two decimal places. I need a formula that will recode them so that anything less than 3 is low, 3 to less than 4 is medium, and 4 or greater is high. Any suggestions? "Between" isn't a code that works, so I'm struggling with how to express that.
Bookmarks