Ok. This is weird. I was playing around with this wondering what is
wrong. I copied and pasted Anthony posted and it didnt work. I screwed
up and and hit delete before I could make a change so I did it again. I
copied and pasted his example but, I picked the wrong one.
=IF( OR(F6="yellow",F6="y",F6="Yellow",F6="Y") ,5,0)
I didnt even notice it until I hit Enter on the keyboard that 5 came up.
But if you notice, the "," are present not ";". Now, if you look at any
other posts I have made its been clear that ";" is what works on my build.
No idea at all what has happened here but, it is working.
Wade
Wade Smart wrote:
Here is what I used:
=IF(OR(F6="yellow";F6="y");5;0)
Note: I did changed from F8 to F6 to test.
Wade
Johnny Rosenberg wrote:
2010/1/28 Wade Smart <[email protected]>:
I still get a 508 error using it.
Error 508 means that parentheses don't match and shouldn't have
anything to do with comparing strings. Check again that you didn't
type one parenthesis too many or if you missed one.
Regards
Johnny Rosenberg
--
Registered Linux User: #480675
Registered Linux Machine: #408606
Linux since June 2005
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
