I need and and/or statement

[soconfused]

I believe I am looking for an OR statement, but I need help.

In column A, I can have either "13A" or "20", if it's either of those two
numbers I want to put a 1 in column B, if it's not either of those numbers I
want to put a 0 in column B.

Can somebody help me write this formula.

Thanks in advance for your help

 

[Eduardo]

Hi,
in column B enter

=if(or(A1="13A",A1=20),1,0)

 

[soconfused]

Thank you, that works perfectly.
--
DMM

Hi,
in column B enter

=if(or(A1="13A",A1=20),1,0)

 

[Eduardo]

your welcom, have a great day

Thank you, that works perfectly.

 

[Teethless mama]

=OR(A1={"13A",20})+0