Prev: vlookup function returning "na" even though the vlaues are present
Next: Variable Labor percentage based off of fixed sales +/-
From: Dave on 20 Mar 2010 04:43
Hi,
XL2003.
Is it possible to use wildcards in simple logic statements?
If A1 contains "qwerty" and B1 contains "qw"
In C1 I've tried:
=A1=B1* - xl complained
=A1=B1&* -xl complained
=A1=B1&"*" - returned FALSE
Regards - Dave.
From: Fred Smith on 20 Mar 2010 05:27
No. You need to use functions like Find or Search, as in:
=isnumber(search(b1,a1))

Regards,
Fred

"Dave" <Dave(a)discussions.microsoft.com> wrote in message
news:B7ACAC8F-2F74-4554-809C-23C01693C242(a)microsoft.com...
> Hi,
> XL2003.
> Is it possible to use wildcards in simple logic statements?
> If A1 contains "qwerty" and B1 contains "qw"
> In C1 I've tried:
> =A1=B1* - xl complained
> =A1=B1&* -xl complained
> =A1=B1&"*" - returned FALSE
> Regards - Dave.

From: Gary''s Student on 20 Mar 2010 05:49
=LEFT(A1,2)=B1

--
Gary''s Student - gsnu201001


"Dave" wrote:

> Hi,
> XL2003.
> Is it possible to use wildcards in simple logic statements?
> If A1 contains "qwerty" and B1 contains "qw"
> In C1 I've tried:
> =A1=B1* - xl complained
> =A1=B1&* -xl complained
> =A1=B1&"*" - returned FALSE
> Regards - Dave.
From: Dave on 20 Mar 2010 06:21
"No" is so final!

"Fred Smith" wrote:

> No. You need to use functions like Find or Search, as in:
> =isnumber(search(b1,a1))
>
> Regards,
> Fred
>
> "Dave" <Dave(a)discussions.microsoft.com> wrote in message
> news:B7ACAC8F-2F74-4554-809C-23C01693C242(a)microsoft.com...
> > Hi,
> > XL2003.
> > Is it possible to use wildcards in simple logic statements?
> > If A1 contains "qwerty" and B1 contains "qw"
> > In C1 I've tried:
> > =A1=B1* - xl complained
> > =A1=B1&* -xl complained
> > =A1=B1&"*" - returned FALSE
> > Regards - Dave.
>
> .
>
From: G Ray on 20 Mar 2010 11:48
What are you trying to do? Are you trying to determine if a1 and b1
are equal? Is this user input?

Glen

On Mar 20, 1:43 am, Dave <D...(a)discussions.microsoft.com> wrote:
> Hi,
> XL2003.
> Is it possible to use wildcards in simple logic statements?
> If A1 contains "qwerty" and B1 contains "qw"
> In C1 I've tried:
> =A1=B1*    - xl complained
> =A1=B1&*      -xl complained
> =A1=B1&"*"    - returned FALSE
> Regards - Dave.

 | 
Pages: 1
Prev: vlookup function returning "na" even though the vlaues are present
Next: Variable Labor percentage based off of fixed sales +/-