# Help With Word Based Excel Formula Using IF/OR Statement

#### mhickman

##### New Member
Hello everyone, so this is what I have so far but this formula does not work for what I am trying to accomplish, can someone help?

=IF(OR(QQ:="Alton","Alamo",["Pharr")”McAllen”)

Basically what I need Excel to do is to render the word "McAllen" in column "V" based off of weather or not there is a match in column "Q" of "Alton", "Alamo" or "Pharr". If column "Q" does not match "Alton", "Alamo" or "Pharr" then I need column "V" to remain blank.

Also, I am using Excel 2013

### Excel Facts

What is the last column in Excel?
Excel columns run from A to Z, AA to AZ, AAA to XFD. The last column is XFD.
Code:
``=IF(OR(Q1="Alton",Q1="Alamo",Q1="Pharr"),"McAllen","")``

I'm wondering is there a way to use multiple if statements in one cell? So please let me try and explain what I am trying to accomplish and then I will show you my current formula.

Like before I am trying to accomplish something very similar but a bit more complex.

Basically what I need Excel to do is to render the word "McAllen" in column "V" based off of weather or not there is a match in column "Q" of "Alton", "Alamo" or "Pharr". If column "Q" does not match "Alton", "Alamo" or "Pharr" then I need column "V" to remain blank.
-or-
If the words "Alpine" or "Alamogordo" are in the "Q" column then the "V" column needs to render "El Paso"; if neither "Alpine" or "Alamogordo" are in column "Q" then again column "V" would need to remain blank.

Here is my current formula:

=IF(OR(Q:Q="Alton",Q:Q="Alamo",Q:Q="Pharr"),"McAllen","") =IF(OR(Q:Q="Alamogordo",Q:Q="Alpine"),"El Paso","")

I don't even know if this is possible but if it is it would save me a huge deal of time.

Thanks again!

Code:
``=IF(OR(Q:Q="Alton",Q:Q="Alamo",Q:Q="Pharr"),"McAllen",IF(OR(Q:Q="Alamogordo",Q:Q="Alpine"),"El Paso",""))``

Code:
``=IF(OR(Q:Q="Alton",Q:Q="Alamo",Q:Q="Pharr"),"McAllen",IF(OR(Q:Q="Alamogordo",Q:Q="Alpine"),"El Paso",""))``

This worked flawlessly, thank you very much Neon!!!

Replies
0
Views
97
Replies
3
Views
64
Replies
11
Views
213
Replies
1
Views
79
Replies
1
Views
150

1,203,674
Messages
6,056,679
Members
444,881
Latest member
Stu2407

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back