IF statement, can it equal more than one number?
 

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

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

Thanks Bob!

"Bob Phillips" wrote:

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

"PhilGTI" wrote in message
...
Thanks Bob!

"Bob Phillips" wrote:

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



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