Help

[kiran]

I have a column with values yes no as mentioned below i want 1 if value is
yes 0 if value is no in next column
yes
no
yes
yes
no
no
yes
yes

 

[Ron de Bruin]

Hi kiran

In B1 use this formula and copy down
=IF(A1="yes",1,0)

 

[Nick Hodge]

Kiran

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

Presumes yes/ no are in column A and are all lower case, copy the formula
down as far as needed

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)

 

[RagDyeR]

If "yes" and "no" are the *only* possible entries in Column A:

=--(A1="yes")

If other entries are possible:

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

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


I have a column with values yes no as mentioned below i want 1 if value is
yes 0 if value is no in next column
yes
no
yes
yes
no
no
yes
yes

 

[Sandy Mann]

Presumes yes/ no are in column A and are all lower case, copy the formula

I don't think that the comparison is case sensitive, is it?

Regards

Sandy

 

[Gord Dibben]

Sandy

My Excel 2002 will return correct results whether lower or upper case.


Gord Dibben Excel MVP