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

Hi Alan,

Maybe you can use something like this:

=IF(OR(J3="ABCD",J3="EFGH"),1,0)

Regards,
Bondi

=IF(OR(j3="ABCD";j3="EFGH");1;0)

Wahur


--
wahur
------------------------------------------------------------------------
wahur's Profile: http://www.excelforum.com/member.php...o&userid=26555
View this thread: http://www.excelforum.com/showthread...hreadid=542832

=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