=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?
>
> --
> 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]
>
>
--
My OpenOffice Calc Website
http://www.openofficetips.com
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
