View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
CLR CLR is offline
external usenet poster
 
Posts: 1,998
Default 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.