Help with formula!!

[aprice]

Hi

I am hoping someone can help me. I have created a list of yes or no i
a cell within my worksheet. In the neighbouring cell I want yes t
represent 1 and no to represent 0. I need to numerics to update itsel
if the list is ever changed from yes to no or visa versa - how do I d
that

 

[BenjieLop]

Hi

I am hoping someone can help me. I have created a list of yes or no in
a cell within my worksheet. In the neighbouring cell I want yes to
represent 1 and no to represent 0. I need to numerics to update itself
if the list is ever changed from yes to no or visa versa - how do I do
that?

This is what you probably need ...

Assuming that your "YES" and "NO" are in Column B, then the
corresponding Column C entry should be

=IF(B1=\"YES\",1,IF(B1=\"NO\",0,\"\"))

and copy down until your range requirements are met.

Regards.

 

[Peo Sjoblom]

yes in A1, in B1 use

=IF(A1="yes",1,if(A1="no",0,""))

 

[Ron Rosenfeld]

Hi

I am hoping someone can help me. I have created a list of yes or no in
a cell within my worksheet. In the neighbouring cell I want yes to
represent 1 and no to represent 0. I need to numerics to update itself
if the list is ever changed from yes to no or visa versa - how do I do
that?

Assuming that your list is in a column of cells, and not in "a cell" as you
wrote:

=--(A1="yes")

will give a 1 for Yes and a 0 for anything else.

If you want a blank if A1 is blank, then:

=IF(ISBLANK(A1),"",--(A1="yes"))




--ron