Status symbols using greater and less than
I"ve been working with a formula for some time without success. I have a column that has an "Action Score" from 1 - 9. I'm trying to have another column display a "Up", "Sideways" or "Down" symbol based on the score.
8 or above gets Up
5 - 7 gets Sideways
1 - 4 gets Down
Here is the formula I've attempted:
=IF([Action Score]@row >= 8, "Up", IF([Action Score]@row <= 4, "Down", IF([Action Score]@row >= 5, [Action Score]@row <= 7, "Sideways")))
It's the Sideways formula that keeps tripping me up. I can't get it to work, though I've tried it multiple ways.
Thanks so much.
Help Article Resources
Check out the Formula Handbook template!