If Function Question

[Guest]

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.

 

[PCLIVE]

Try this for one way:

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

HTH,
Paul

 

[Guest]

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

Vaya con Dios,
Chuck, CABGx3

 

[Gord Dibben]

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


Gord Dibben MS Excel MVP

 

[Gord Dibben]

I like this shorter version.

Thanks Chuck.


Gord

 

[Guest]

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]

So it was<g>

Thanks Paul

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

 

[PCLIVE]

You're welcome.

So it was<g>

Thanks Paul