B Bob Phillips Jan 25, 2005 #2 in another cell? =IF(AND(A1<>"yes",A1<>"no"),"",(A1="yes")*1+(A1="no")*0) -- HTH RP (remove nothere from the email address if mailing direct) "can I make cell yes equal 1, no equa" <can I make cell "yes" equal 1, "no" (e-mail address removed)> wrote in message news:[email protected]...
in another cell? =IF(AND(A1<>"yes",A1<>"no"),"",(A1="yes")*1+(A1="no")*0) -- HTH RP (remove nothere from the email address if mailing direct) "can I make cell yes equal 1, no equa" <can I make cell "yes" equal 1, "no" (e-mail address removed)> wrote in message news:[email protected]...
S Sandy Mann Jan 25, 2005 #3 Picky but I don't think that you need the " +(A1="no")*0 " Just =IF(AND(A1<>"yes",A1<>"no"),"",(A1="yes")*1) or =IF(AND(A1<>"yes",A1<>"no"),"",--(A1="yes")) will work Regards Sandy
Picky but I don't think that you need the " +(A1="no")*0 " Just =IF(AND(A1<>"yes",A1<>"no"),"",(A1="yes")*1) or =IF(AND(A1<>"yes",A1<>"no"),"",--(A1="yes")) will work Regards Sandy
B Bob Phillips Jan 25, 2005 #4 Hi Sandy, Quite right, well spotted. Bob Sandy Mann said: Picky but I don't think that you need the " +(A1="no")*0 " Just =IF(AND(A1<>"yes",A1<>"no"),"",(A1="yes")*1) or =IF(AND(A1<>"yes",A1<>"no"),"",--(A1="yes")) will work Regards Sandy Click to expand...
Hi Sandy, Quite right, well spotted. Bob Sandy Mann said: Picky but I don't think that you need the " +(A1="no")*0 " Just =IF(AND(A1<>"yes",A1<>"no"),"",(A1="yes")*1) or =IF(AND(A1<>"yes",A1<>"no"),"",--(A1="yes")) will work Regards Sandy Click to expand...
