View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Teethless mama Teethless mama is offline
external usenet poster
 
Posts: 3,718
Default I need and and/or statement

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

"soconfused" wrote:

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



--
DMM