Excel if problem

[johnbracey25]

Hi guys,

I am trying to turn a list of "yes", "no" into 1,0. I tried the formula =IF(N3 = "no",1,IF(N3= "yes",1,0)) but it didn't work... Can anyone offer up any assistance? Thanks!

 

[mvptomlinson]

Hi John, use:

=IF(N3="no",1,0)

Usually, No/False is 0, and Yes/True is 1, but if yours needs to be the opposite and it works, so be it.

 

[T. Valko]

Hi guys,

I am trying to turn a list of "yes", "no" into 1,0. I tried the formula =IF(N3 = "no",1,IF(N3= "yes",1,0)) but it didn't work... Can anyone offer up any assistance? Thanks!

Your formula will return 1 for both Yes and NO.

Assuming the only possible entries are Yes or NO, this formula will return 1 for Yes and 0 for ANYTHING else (except for errors).

=--(N3="yes")

 

[RSXchin]

Why not find/replace "yes" with "1" and "no" with "0"?

 

[johnbracey25]

I tried that and it didn't work... really frustrated that such a simple formula isn't working... One thing I didn't mention though... The variables are named "yes" "no" WITH the parentheses already on them...

 

[johnbracey25]

Thanks! The find/replace idea worked like a peach. You guys all rock!!

 

[RSXchin]

change "yes" to ""yes"" and "no" to ""no""

 

[mvptomlinson]

If your yes and no values actually have quotation marks around them (e.g. "yes" and "no") then try:

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

or

=--(E10="""yes""")