to semicolons.
tc
From: Wade Smart w...@wadesmart.com
To: users@openoffice.org
Sent: Thu, January 28, 2010 8:24:15 AM
Subject: Re: [users] Using an OR inside an IF
Were you able to run this in a spread sheet cell?
Documentation says you can compare words, only
...@unitybox.de:
Streich mich endlich von der Liste
- Original Message -
From: Wade Smart w...@wadesmart.com
To: users@openoffice.org
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
)
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
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
,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
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
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 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
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(
Hello together
Semicolon or comma - this is also a matter of discontinued language in
the document
In German, the separator always is between the blocks a ; in the
English-language versions a ,
But I have another others resolution: (separator is this ;, because I
installed the German
You tested for only Y when there are several other possibilities.
Wade
Franz Wein wrote:
Hello together
Semicolon or comma - this is also a matter of discontinued language in
the document
In German, the separator always is between the blocks a ; in the
English-language versions a ,
But I
Streich mich endlich von der Liste
- Original Message -
From: Wade Smart w...@wadesmart.com
To: users@openoffice.org
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
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
=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
2010/1/26 Wade Smart w...@wadesmart.com:
=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
Hello
Guy Voets wrote:
2010/1/26 Wade Smart w...@wadesmart.com:
=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?
2010/1/26 Wade Smart w...@wadesmart.com:
=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?
This works (I
2010/1/26 Johnny Rosenberg gurus.knu...@gmail.com
2010/1/26 Wade Smart w...@wadesmart.com:
=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
17 matches
Mail list logo