Checking for two values

[Terry Freedman]

Hi, sorry if this is a really easy question but it's driving me nuts
because nothing I've tried seems to work. Basically, I am looking for
a way to do this:

If cell A1 contains the word "email" and cell B1 contains "@", give
the result 1, otherwise give the result 0.

I have tried using the AND function and wildcards, but I either get an
error message or it returns an incorrect result.

Can anyone help please?

Thanks very much
Terry

 

[Dave Peterson]

One way:

=--and(countif(a1,"*email*")>0,countif(b1,"*@*")>0)

=and() will return True or False. The -- stuff changes the booleans to numbers.

 

[Bernie Deitrick]

Terry,

Basically:

=IF(AND(A1="email",B1="@"),1,0)

though it depends on your meaning of contains. The above is exact and exclusionary...this looks for
a string containing the @

=IF(AND(A1="email",NOT(ISERROR(FIND("@",B1)))),1,0)

HTH,
Bernie
MS Excel MVP

 

[Terry Freedman]

One way:

=--and(countif(a1,"*email*")>0,countif(b1,"*@*")>0)

=and() will return True or False.  The -- stuff changes the booleans to numbers.

Thank you!!! You have prevented my being carted off to an asylum. I
didn't know about -- either.
All the best
Terry