can I make cell "yes" equal 1, "no" equal 0

B

Bob Phillips

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

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

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...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

cell on sheet 1 equals cell on sheet two 2
if(a1=b1=c1,1,0) is 0 when should be 1, why? 3
Subtracting From Multiple Cells Until 0 1
What command can I use to see if any cells equal the same. 2
Equal to zero ... or not equal to zero 1
When calling a different file, can I make the tab equal to a cell? 1
How to make +'sheet 1'A1 not show up as zero 3
Cells equal to another cell a certain # over 6

Top