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 > I still think its odd that I use ; and others use , so I guess some can do > that with text and others, like me, cant :D > > Wade > > Johnny Rosenberg wrote: >> >> 2010/1/28 Wade Smart <[email protected]>: >>> >>> Were you able to run this in a spread sheet cell? >>> Documentation says you can compare words, only numbers. >> >> I think they mean that things like >> =IF("Johnny">"Rosenberg";"Yes";"No") doesn't make much sense. But you >> can still test for = and ≠ (<>). >> >> >> Regards >> >> Johnny Rosenberg >> >> >>> Wade >>> >>> >>> Anthony Chilco wrote: >>>> >>>> Hi Wade, >>>> Off the top of my head, I'd say it should read >>>> =IF(OR(F8="yellow",F8="y"),5,0) >>>> Of course, I had to use semicolons to test it. >>>> =IF(OR(F8="yellow";F8="y");5;0) >>>> tc >>>> >>>> >>>> >>>> >>>> ________________________________ >>>> From: Wade Smart <[email protected]> >>>> To: OpenOffice <[email protected]> >>>> Sent: Tue, January 26, 2010 8:59:58 AM >>>> Subject: [users] Using an OR inside an IF >>>> >>>> =IF(F8=(OR("yellow","y")),5,0) >>>> >>>> IF, F8 is equal to the word "yellow" or the letter "y" then return the >>>> number 5, otherwise return 0. >>>> >>>> Im getting that #VALUE! error. >>>> >>>> ah.. I just read that any text cells are ignored. >>>> How would I do that then? >>>> >>>> Wade >>>> -- 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] >>>> >>>> >>>> __________________________________________________________________ >>>> Looking for the perfect gift? Give the gift of Flickr! >>>> http://www.flickr.com/gift/ >>> >>> -- >>> 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] >>> >>> >> >> --------------------------------------------------------------------- >> To unsubscribe, e-mail: [email protected] >> For additional commands, e-mail: [email protected] >> >> > > > -- > 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] > > --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
