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]