=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.
Ive got it to work with a single commodity code-
=IF(AD2="125","A",(IF(D2="160","C","O")))

Ive tried using the formula above but I dont 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.