AND function

[london_lad]

Hi people

I'm troubled with the AND function. This is what I have:

A1 reads AWAY
A2 reads EESL

In A3 I would like the number 1 to be shown if AWAY and EESL ar
present. If not, an 0. I've tried every which way to work this out o
my own, but with no success.

Any suggestions?

Nei

 

[Frank Kabel]

Hi
try the following in A3
=IF(AND(A1="AWAY",A2="EESL"),1,0)

 

[Bernard V Liengme]

Hi London_lad
Frank's answer is just fine but this also works =(A1="away")*(A2="eesl")
Bernard
(once-upon-a-time-a-London-lad)

 

[Frank Kabel]

nice one

 

[london_lad]

Cheers to Frank and everyone else who helped! I'm now IF and AND ing
correctly!

 

[www.canhelpyou.com]

Another way to look at it is:

=IF((A1="AWAY")*(A2="EESL"),1,0)

Hint: When you're dealing with logic like "IF"
statements, the * is a logical "and" and the + is a
logical "or".

I've found it actually easier to use this than the AND()
and OR() but to each his own.


Kent