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!
==============================================
"kiran" wrote in message
...
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
|