Yes, you can make cell "yes" equal 1 and "no" equal 0 in Microsoft Excel. Here's how:

1. Select the cell where you want to enter the formula.
2. Type the following formula:
   Formula:

   =IF(A1="yes",1,0) 

3. Press Enter.

This formula checks if the value in cell A1 is "yes". If it is, the formula returns 1. If it's not, the formula returns 0.

You can also copy this formula to other cells by dragging the fill handle (the small square at the bottom right corner of the cell) to the cells where you want to apply the formula.

Alternatively, you can use the IF function with logical operators to check for other values besides "yes" and "no". For example, if you want to check for "true" and "false", you can use the following formula:

in another cell?

=IF(AND(A1<"yes",A1<"no"),"",(A1="yes")*1+(A1="n o")*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"
wrote in message
...

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
--
to e-mail direct replace @mailintor.com with @tiscali.co.uk


"Bob Phillips" wrote in message
...
in another cell?

=IF(AND(A1<"yes",A1<"no"),"",(A1="yes")*1+(A1="n o")*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"
wrote in message
...

Hi Sandy,

Quite right, well spotted.

Bob

"Sandy Mann" wrote in message
...
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
--
to e-mail direct replace @mailintor.com with @tiscali.co.uk


"Bob Phillips" wrote in message
...
in another cell?

=IF(AND(A1<"yes",A1<"no"),"",(A1="yes")*1+(A1="n o")*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"
wrote in message
...