On Tue, 20 Sep 2005 10:05:18 -0700, David Chapman wrote:
>=IF(FIND("card";LOWER(C14));1;0)
>
>On 9/20/05, GregChi <[EMAIL PROTECTED]> wrote:
>> working with OOo 1.9.125:
>>
>> cell C14: "Debit Card Purchase: Exxonmobil75"
>> formula in H14: "=IF(FIND("Card";C14);1;0)"
>> results : 1
>>
>> cell c14: "Debit ard Purchase: Exxonmobil75"
>> formula in H14: "=IF(FIND("Card";C14);1;0)"
>> results : #VALUE!
>>
>> cell C14: "Debit Card Purchase: Exxonmobil75"
>> if formula in H14: "=IF(FIND("card";C14);1;0)"
>> results : #VALUE!
>>
>> cell C14: "Debit Card Purchase: Exxonmobil75"
>> if formula in H14: "=IF(FIND(LOWER("Card");C14);1;0)"
>> or
>> if formula in H14: "=IF(FIND(LOWER("card");C14);1;0)"
>> results : #VALUE!
>>
>>
>> (This appears to be the same in ver 1.1.4)
>>
>> What is the formula to determine if (case-insensitive) the word
>> "card" is in the cell?
>>
>> Are there syntax examples of various formulas?
>> Where?
Thank You!
Now, if the word 'card' or 'Card' is removed from C14 I again get the error
#VALUE!
Doesn't IF mean if true do this else that? IF(xxx ; is true ; is false)
--
Greg Agent 1.93/32.576 Opera8 OOo 2(19125)
news.readfreenews.net & news.gmane.org Win98se
for sale: Apple//,Auto Parts/Equip/Manuals: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
