IF statement, can it equal more than one number?

[PhilGTI]

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

 

[Bob Phillips]

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

Thanks Bob!

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

 

[Fredrik Wahlgren]

Thanks Bob!

If you have lots of formulas like these, you should consider making a User
Defined Function.
/Fredrik