J jack172 Joined Oct 31, 2013 Messages 1 Reaction score 0 Oct 31, 2013 #1 Hi, Basically I need a formula that says, if cell A1 is equal to either 1, 4, or 7, put a 1 in this cell, otherwise put a zero. How can I do this? I appreciate any help you can offer!
Hi, Basically I need a formula that says, if cell A1 is equal to either 1, 4, or 7, put a 1 in this cell, otherwise put a zero. How can I do this? I appreciate any help you can offer!
P p45cal Joined Dec 15, 2009 Messages 5 Reaction score 0 Nov 2, 2013 #2 =IF(OR(A1=1,A1=4,A1=7),1,"") or =IF(ISERROR(MATCH(A1,{1,4,7},0)),"",1)
