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.