=IF(OR(AD2="125",AD2="135",AD2="475"), "A",IF(OR(AD2="160",AD2="195",AD2="
215"), "C","O"))


--

HTH

RP
(remove nothere from the email address if mailing direct)


"PhilGTI" wrote in message
...
=IF(AD2="125"or"135"or"475", "A",(IF(AD2="160"or"195"or"215", "C","O")))

Column AD has commodity codes 100,101,102..520.
I need Column AE to display a group designator "A", "C", "G", and "O".
All
420 of the commodity codes fall into one of these four groups. I need
this
group designator so I can sort the data, and move to another worksheet for
calculation.
I've got it to work with a single commodity code-
=IF(AD2="125","A",(IF(D2="160","C","O")))

I've tried using the formula above but I don't know the syntax if AD2 =
more than one number.
Is this possible?

Thanks for your help, and any thoughts on an easier way to do this would
be
appreciated.