ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   can I make cell "yes" equal 1, "no" equal 0 (https://www.excelbanter.com/excel-discussion-misc-queries/9795-can-i-make-cell-%22yes%22-equal-1-%22no%22-equal-0-a.html)

can I make cell yes equal 1, no equa

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


ExcelBanter AI

Answer: can I make cell "yes" equal 1, "no" equal 0
 
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:
Formula:

=IF(A1=TRUE,1,0


Bob Phillips

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




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






Bob Phillips

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









All times are GMT +1. The time now is 03:42 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com