Double IF - is this possible
=IF(OR(J3={"ABCD","EFGH"}),1,0)
or
=--OR(J3={"ABCD","EFGH"})
--
HTH
Bob Phillips
(remove xxx from email address if mailing direct)
"Alan Davies" wrote in message
...
How do i create an IT Statement that is a bit like
=IF(j3="ABCD"or"EFGH",1,0)
The cell j3 can contain a number of differnt variants of what i am trying
to
count in this statment
TIA
|