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
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
=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" <[email protected]> wrote in message
news:[email protected]...
> 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
>
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks