2010/1/28 Wade Smart <w...@wadesmart.com>:
> 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 <w...@wadesmart.com>:
>>>
>>> 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 <w...@wadesmart.com>
>>>> To: OpenOffice <users@openoffice.org>
>>>> 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: users-unsubscr...@openoffice.org
>>>> For additional commands, e-mail: users-h...@openoffice.org
>>>>
>>>>
>>>> __________________________________________________________________
>>>> 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: users-unsubscr...@openoffice.org
>>> For additional commands, e-mail: users-h...@openoffice.org
>>>
>>>
>>
>> ---------------------------------------------------------------------
>> To unsubscribe, e-mail: users-unsubscr...@openoffice.org
>> For additional commands, e-mail: users-h...@openoffice.org
>>
>>
>
>
> --
> Registered Linux User: #480675
> Registered Linux Machine: #408606
> Linux since June 2005
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: users-unsubscr...@openoffice.org
> For additional commands, e-mail: users-h...@openoffice.org
>
>
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscr...@openoffice.org
For additional commands, e-mail: users-h...@openoffice.org
