Streich mich endlich von der Liste
----- Original Message -----
From: "Wade Smart" <[email protected]>
To: <[email protected]>
Sent: Thursday, January 28, 2010 7:26 PM
Subject: Re: [users] Using an OR inside an IF
I still get a 508 error using it.
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]
