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.