Alfa Romeo Forum - View Single Post - Excel formula help.
You are currently unregistered, register for more features.    
View Single Post
(Post Link) post #6 of Old 30-09-13 Thread Starter
bazza
Status: Daddy bear
Global Mod Team
 
bazza's Avatar
 
Join Date: Nov 2002
Location: Congleton - The centre of
Posts: 44,732

Member car:

AMG C63 estate

Quote:
Originally Posted by TonyGr View Post
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.

Quote:
Originally Posted by scottyf View Post
Why can you not just put....

=IF(B7>499,"X","Y")

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?

Seen an offensive/spam post? Report it! Click the or button next to the post.
AO Rules - AO Gallery - AO Classified adverts - AO Club - AO Traders

"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.
bazza is offline  
 
 
For the best viewing experience please update your browser to Google Chrome