can I make cell "yes" equal 1, "no" equal 0

in another cell?

=IF(AND(A1<>"yes",A1<>"no"),"",(A1="yes")*1+(A1="no")*0)

--

HTH

RP
(remove nothere from the email address if mailing direct)


"can I make cell yes equal 1, no equa" <can I make cell "yes" equal 1, "no"
[email protected]> wrote in message
news:[email protected]...
>

Picky but I don't think that you need the " +(A1="no")*0 " Just

=IF(AND(A1<>"yes",A1<>"no"),"",(A1="yes")*1)

or

=IF(AND(A1<>"yes",A1<>"no"),"",--(A1="yes"))

will work

Regards

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


"Bob Phillips" <[email protected]> wrote in message
news:%[email protected]...
> in another cell?
>
> =IF(AND(A1<>"yes",A1<>"no"),"",(A1="yes")*1+(A1="no")*0)
>
> --
>
> HTH
>
> RP
> (remove nothere from the email address if mailing direct)
>
>
> "can I make cell yes equal 1, no equa" <can I make cell "yes" equal 1,
"no"
> [email protected]> wrote in message
> news:[email protected]...
> >
>
>

Hi Sandy,

Quite right, well spotted.

Bob

"Sandy Mann" <[email protected]> wrote in message
news:%[email protected]...
> Picky but I don't think that you need the " +(A1="no")*0 " Just
>
> =IF(AND(A1<>"yes",A1<>"no"),"",(A1="yes")*1)
>
> or
>
> =IF(AND(A1<>"yes",A1<>"no"),"",--(A1="yes"))
>
> will work
>
> Regards
>
> Sandy
> --
> to e-mail direct replace @mailintor.com with @tiscali.co.uk
>
>
> "Bob Phillips" <[email protected]> wrote in message
> news:%[email protected]...
> > in another cell?
> >
> > =IF(AND(A1<>"yes",A1<>"no"),"",(A1="yes")*1+(A1="no")*0)
> >
> > --
> >
> > HTH
> >
> > RP
> > (remove nothere from the email address if mailing direct)
> >
> >
> > "can I make cell yes equal 1, no equa" <can I make cell "yes" equal 1,
> "no"
> > [email protected]> wrote in message
> > news:[email protected]...
> > >
> >
> >
>
>