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
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
Hi kiran
In B1 use this formula and copy down
=IF(A1="yes",1,0)
--
Regards Ron de Bruin
http://www.rondebruin.nl
"kiran" <[email protected]> wrote in message news:[email protected]...
>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
>
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
[email protected]HIS
"kiran" <[email protected]> wrote in message
news:[email protected]...
>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
>
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" <[email protected]> wrote in message
news:[email protected]...
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
> 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" <[email protected]> wrote in message
news:[email protected]...
> 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
> [email protected]HIS
>
>
> "kiran" <[email protected]> wrote in message
> news:[email protected]...
> >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
My Excel 2002 will return correct results whether lower or upper case.
Gord Dibben Excel MVP
On Tue, 25 Jan 2005 17:45:27 -0000, "Sandy Mann" <[email protected]>
wrote:
>> 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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks