=IF(ISERR(FIND("card";LOWER(D8)));0;1)
On 9/20/05, GregChi <[EMAIL PROTECTED]> wrote:
>
> On Tue, 20 Sep 2005 10:05:18 -0700, David Chapman wrote:
>
> >=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?
>
>
> Thank You!
> Now, if the word 'card' or 'Card' is removed from C14 I again get the
> error #VALUE!
>
> Doesn't IF mean if true do this else that? IF(xxx ; is true ; is false)
>
> --
> Greg Agent 1.93/32.576 Opera8 OOo 2(19125)
> news.readfreenews.net <http://news.readfreenews.net> &
> news.gmane.org<http://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
