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