So, I have a field that returns a number. I need a formula that will return text based on that number:
less than 30 = poor
less than 50 = below average
50 to 60 = normal
60+ = above average
70+ = excellent
Thoughts? When I wrote it out, it would work for anything less than 50, but for anything more it always returns "normal". Got somthing to do with how it reads the > sign, I think, but I'm not sure.
Thanks!
Bookmarks