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]
