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?
--
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]
