can I make cell "yes" equal 1, "no" equal 0
|
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:
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:
|
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 ... |
All times are GMT +1. The time now is 03:42 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com