software

How do i create an IT Statement that is a bit like
=IF(j3=quot;ABCDquot;orquot;EFGHquot;,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=quot;ABCDquot;,J3=quot;EFGHquot;),1,0)

Regards,
Bondi
=IF(OR(j3=quot;ABCDquot;;j3=quot;EFGHquot;);1;0)

Wahur--
wahur
------------------------------------------------------------------------
wahur's Profile: www.excelforum.com/member.php...oamp;userid=26555
View this thread: www.excelforum.com/showthread...hreadid=542832=IF(OR(J3={quot;ABCDquot;,quot;EFGHquot;}),1,0)

or

=--OR(J3={quot;ABCDquot;,quot;EFGHquot;})--
HTH

Bob Phillips

(remove xxx from email address if mailing direct)

quot;Alan Daviesquot; gt; wrote in message
...
gt; How do i create an IT Statement that is a bit like
gt; =IF(j3=quot;ABCDquot;orquot;EFGHquot;,1,0)
gt;
gt; The cell j3 can contain a number of differnt variants of what i am trying
to
gt; count in this statment
gt;
gt; TIA
gt;
gt;