There is no bug here. All formulae working as expected. Look carefully at original poster's formulae and my correction.
Dave On 9/20/05, cono <[EMAIL PROTECTED]> wrote: > 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] > > -- My OpenOffice Calc Website http://www.openofficetips.com --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
