J
jaywizz
I have a stats sheet on a workbook and I would like to be able to get it to
read a "Yes" as a 1 and a "No" as a 0
Thanks for your help
read a "Yes" as a 1 and a "No" as a 0
Thanks for your help
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
M
Mike H
Hi,
You don't say how you get YES or NO but this formula looks at A1 and if the
result of a formula in that cell is YES or No or there is a text Yes or No
then this returns 1 or 0
=IF(A1="Yes",1,IF(A1="No",0,""))
Mike
You don't say how you get YES or NO but this formula looks at A1 and if the
result of a formula in that cell is YES or No or there is a text Yes or No
then this returns 1 or 0
=IF(A1="Yes",1,IF(A1="No",0,""))
Mike
D
David Biddulph
=IF(A2="Yes",1,IF(A2="No",0,"undefined"))
If it will always be one or the other, you might use =--(A2="Yes")
If it will always be one or the other, you might use =--(A2="Yes")
R
Roger Govier
Hi
Mike has given you a method of carrying out the conversion.
If you are wanting to do this just so you can count the number of Yes
values, you don't need to convert to numbers first
=COUNTIF(A:A,"Yes") will count the number of Yes values in column A.
Substitute "No" for the alternative result.
Mike has given you a method of carrying out the conversion.
If you are wanting to do this just so you can count the number of Yes
values, you don't need to convert to numbers first
=COUNTIF(A:A,"Yes") will count the number of Yes values in column A.
Substitute "No" for the alternative result.