Home |
Search |
Today's Posts |
#1
|
|||
|
|||
IF statement, can it equal more than one number?
=IF(AD2=125or135or475, A,(IF(AD2=160or195or215, 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. |
#2
|
|||
|
|||
=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. |
#3
|
|||
|
|||
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. |
#4
|
|||
|
|||
"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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Seed numbers for random number generation, uniform distribution | Excel Discussion (Misc queries) | |||
How do I fix a circular reference in a financial statement? | Excel Discussion (Misc queries) | |||
when writing an IF statement what is the syntax for "Not Equal to. | Excel Discussion (Misc queries) | |||
when writing an IF statement what is the syntax for "Not Equal to. | Excel Discussion (Misc queries) | |||
GET.CELL | Excel Worksheet Functions |