According to my Excel Right is a function used with text strings so is the if statement treating the answer to the right function as test and returning the value for true every time?
Yeah, that's what I wondered. It's returning "498", but treating it as a text string so not recognising it as less than 499. I could easily test this I guess by making it > instead and swapping y and x. If it's still picking the value which is false, then potential proof.
Why can you not just put....
Rather than adding the formular "Right"
Because the contents of B7 aren't a 3 digit number. In fact, they're not even wholly numerical - but the last three digits being above or below 500 tell me an important fact about that piece of data, hence wanting to label based on it.
So does anyone have another easy way to do this?
"Human beings, who are almost unique in having the ability to learn from the experience of others, are also remarkable for their apparent disinclination to do so." - Douglas Adams
"You know, sometimes the world seems like a pretty mean place."
"That's why animals are so soft and huggy."
- Calvin and Hobbes
To err is human, to moderate ursine.