I am having some difficulty creating a formula in my Sharepoint List. I have a column that is a list of countries and I am trying to create a formula that will check the value of the column and spit out a specific response based on the value. So if the country is Afghanistan, I want it to report in the column "CENTCOM". If it is Kenya, then "AFRICOM", etc. I have the list of the all the countries and I can jam them all into the formula, I'm just not sure of the syntax. Is there some way to do it like "=IF(Country="Afghanistan","CENTCOM" but instead of just listing one country, actually put a list of countries in there? And then if the country is not on that list, move to the next list?
I'm sorry if this is confusing, I'm new to this and trying to figure this out with no prior programming experience. Thanks for your help!