Prev: Finding most recent date for each customer - XL 2007
Next: Sumif Function
From: Alyssa on 30 Apr 2010 15:28
Hi,

I have a column that has a series of numbers it will always be either 10000
or 10100 , I want it to return a No for 10000 or Yes for 10100 in the field
next to it,

I have tried and I can't seem to make it work, I can do one or the other,
any assistance would be greatly appreciated.

The cells I am using for example are BF20 to BF34 and the answer I want to
go into BG20 to BG34

Thanks!!!!
From: Bob Phillips on 30 Apr 2010 15:34
BG20: =IF(BF20=10000,"No","Yes")

and copy down

--

HTH

Bob

"Alyssa" <Alyssa(a)discussions.microsoft.com> wrote in message
news:2AB76714-246C-4B93-9362-AC7808F6F751(a)microsoft.com...
> Hi,
>
> I have a column that has a series of numbers it will always be either
> 10000
> or 10100 , I want it to return a No for 10000 or Yes for 10100 in the
> field
> next to it,
>
> I have tried and I can't seem to make it work, I can do one or the other,
> any assistance would be greatly appreciated.
>
> The cells I am using for example are BF20 to BF34 and the answer I want to
> go into BG20 to BG34
>
> Thanks!!!!


From: FSt1 on 30 Apr 2010 15:50
hi
=IF(BG20=10000,"No","Yes")

regars
FSt1

"Alyssa" wrote:

> Hi,
>
> I have a column that has a series of numbers it will always be either 10000
> or 10100 , I want it to return a No for 10000 or Yes for 10100 in the field
> next to it,
>
> I have tried and I can't seem to make it work, I can do one or the other,
> any assistance would be greatly appreciated.
>
> The cells I am using for example are BF20 to BF34 and the answer I want to
> go into BG20 to BG34
>
> Thanks!!!!
From: FSt1 on 30 Apr 2010 17:16
oops.
that should be
=IF(BF20=10000,"No","Yes")

sorry.
FSt1

"FSt1" wrote:

> hi
> =IF(BG20=10000,"No","Yes")
>
> regars
> FSt1
>
> "Alyssa" wrote:
>
> > Hi,
> >
> > I have a column that has a series of numbers it will always be either 10000
> > or 10100 , I want it to return a No for 10000 or Yes for 10100 in the field
> > next to it,
> >
> > I have tried and I can't seem to make it work, I can do one or the other,
> > any assistance would be greatly appreciated.
> >
> > The cells I am using for example are BF20 to BF34 and the answer I want to
> > go into BG20 to BG34
> >
> > Thanks!!!!
 | 
Pages: 1
Prev: Finding most recent date for each customer - XL 2007
Next: Sumif Function