Words equal numbers

  • Thread starter Thread starter jaywizz
  • Start date Start date
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
 
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
 
=IF(A2="Yes",1,IF(A2="No",0,"undefined"))
If it will always be one or the other, you might use =--(A2="Yes")
 
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.
 
You must log in or register to reply here.

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

Roundup percent within existing formula? 7
Excel Need Countifs Formula Help 0
How to locate which cells add up less than or equal to a certainnumber (where numbers can be repeate 1
Error Installing "ADAPTEC EZCD 4.04" 1
How do I get totals from several different worksheets on to one? 1
Alt codes 4
add a link 1
Date Format 2

Back
Top