Hi,
Is this http://www.openoffice.org/issues/show_bug.cgi?id=52584
??
Greetings,
Cor
GregChi 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?
--
Cor Nouws
http://www.nouenoff.nl
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
