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

--
to e-mail direct replace @mailintor.com with @tiscali.co.uk


"Nick Hodge" wrote in message
...
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
HIS


"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