AND function

  • Thread starter Thread starter london_lad
  • Start date Start date
L

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
 
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)
 
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
 
Back
Top