If Function Question
 

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 Function Question
 

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 Function Question
 

=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 Function Question
 

=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.

If Function Question
 

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.

If Function Question
 

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.

If Function Question
 

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.

If Function Question
 

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.