This should be easy. I have an if function ..
=If(g17=21or31or40or50,"segragated","non segregated")
My question is how do I make it so that if g17 equals 21 or 31 or 40 or 50,
then you will get segregated for true and non segregated for false.

Try this for one way:

=IF(OR(G17={21,31,40,50}),"segragated","non segregated")

HTH,
Paul


"Schwimms" wrote in message
...
This should be easy. I have an if function ..
=If(g17=21or31or40or50,"segragated","non segregated")
My question is how do I make it so that if g17 equals 21 or 31 or 40 or
50,
then you will get segregated for true and non segregated for false.

=IF(OR(G17=21,G17=31,G17=40,G17=50),"segragated"," non segregated")

Vaya con Dios,
Chuck, CABGx3



"Schwimms" wrote:

This should be easy. I have an if function ..
=If(g17=21or31or40or50,"segragated","non segregated")
My question is how do I make it so that if g17 equals 21 or 31 or 40 or 50,
then you will get segregated for true and non segregated for false.

=IF(OR(g17=21,g17=31,g17=40,g17=50),"segregated"," non segregated")


Gord Dibben MS Excel MVP

On Tue, 31 Jul 2007 09:10:03 -0700, Schwimms
wrote:

This should be easy. I have an if function ..
=If(g17=21or31or40or50,"segragated","non segregated")
My question is how do I make it so that if g17 equals 21 or 31 or 40 or 50,
then you will get segregated for true and non segregated for false.

I like this shorter version.

Thanks Chuck.


Gord

On Tue, 31 Jul 2007 12:15:14 -0400, "PCLIVE" wrote:

Try this for one way:

=IF(OR(G17={21,31,40,50}),"segragated","non segregated")

HTH,
Paul


"Schwimms" wrote in message
...
This should be easy. I have an if function ..
=If(g17=21or31or40or50,"segragated","non segregated")
My question is how do I make it so that if g17 equals 21 or 31 or 40 or
50,
then you will get segregated for true and non segregated for false.

You're welcome.....but I posted the same thing you did......it was Paul who
offered the nifty shorter version.


Vaya con Dios,
Chuck, CABGx3


"Gord Dibben" wrote:

I like this shorter version.

Thanks Chuck.


Gord

On Tue, 31 Jul 2007 12:15:14 -0400, "PCLIVE" wrote:

Try this for one way:

=IF(OR(G17={21,31,40,50}),"segragated","non segregated")

HTH,
Paul


"Schwimms" wrote in message
...
This should be easy. I have an if function ..
=If(g17=21or31or40or50,"segragated","non segregated")
My question is how do I make it so that if g17 equals 21 or 31 or 40 or
50,
then you will get segregated for true and non segregated for false.

So it was<g

Thanks Paul

On Tue, 31 Jul 2007 10:06:01 -0700, CLR wrote:

You're welcome.....but I posted the same thing you did......it was Paul who
offered the nifty shorter version.


Vaya con Dios,
Chuck, CABGx3


"Gord Dibben" wrote:

I like this shorter version.

Thanks Chuck.


Gord

On Tue, 31 Jul 2007 12:15:14 -0400, "PCLIVE" wrote:

Try this for one way:

=IF(OR(G17={21,31,40,50}),"segragated","non segregated")

HTH,
Paul


"Schwimms" wrote in message
...
This should be easy. I have an if function ..
=If(g17=21or31or40or50,"segragated","non segregated")
My question is how do I make it so that if g17 equals 21 or 31 or 40 or
50,
then you will get segregated for true and non segregated for false.

You're welcome.

"Gord Dibben" <gorddibbATshawDOTca wrote in message
...
So it was<g

Thanks Paul

On Tue, 31 Jul 2007 10:06:01 -0700, CLR
wrote:

You're welcome.....but I posted the same thing you did......it was Paul
who
offered the nifty shorter version.


Vaya con Dios,
Chuck, CABGx3


"Gord Dibben" wrote:

I like this shorter version.

Thanks Chuck.


Gord

On Tue, 31 Jul 2007 12:15:14 -0400, "PCLIVE"
wrote:

Try this for one way:

=IF(OR(G17={21,31,40,50}),"segragated","non segregated")

HTH,
Paul


"Schwimms" wrote in message
...
This should be easy. I have an if function ..
=If(g17=21or31or40or50,"segragated","non segregated")
My question is how do I make it so that if g17 equals 21 or 31 or 40
or
50,
then you will get segregated for true and non segregated for false.