Stringing IF/OR statements in a single formula
I am trying to string multiple IF/OR statements together. To summarize, if the column Location contains London, Brussels or Moscow, the resulting value should be Europe. If the Location column contains Dubai or Riyadh, the value should be Middle East. If the Location column contains any other value, the result should be the existing value from the Location field.
This formula works.
=IF(OR(Location@row = "London", Location@row = "Brussels", Location@row = "Moscow"), "Europe", Location@row)
However, I need to include the following to the above formula:
=IF(OR(Location@row = "Dubai", Location@row = "Riyadh"), "Middle East", Location@row)
I have tried so many variations and can't seem to get this to work. If anyone has a suggestion, I would be greatly appreciative.
Help Article Resources
Check out the Formula Handbook template!