View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
soconfused soconfused is offline
external usenet poster
 
Posts: 93
Default I need and and/or statement

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