Combining Multiple IF Statements

Hi I am new to the forum but have looked at some of the posts before when I have needed some help. I hope that I am following the rules.

I have Office 2010

I am trying to combine multiple If statements in an Excel Spreadsheet. Here is my problem.

One column I have a list of countries. I want to separate the countries by their Country Code = Americas, EMEAR, APJC

Eg. Column A has the following countries Canada
USA
India
China
Ireland
Spain

I want Column B to give the Corresponding country Code, so it should look like this"

Column A | Column B
Canada | Americas
USA | Americas
India | APJC
China | APJC
Ireland | EMEAR
Spain | EMEAR

I can get it to work with only one if statement: =IF(OR(A1="United States", A1="Canada"), "Americas", "")
This gives me the Americas but I want it to populate for the other countries as well. I hope this makes sense


Thanks,

Thank you sooo much, Worked like a charm, you are awesome!!!!!!!!!!!!!!!!