AnsweredAssumed Answered

Multiple Tests in IF Statement?

Question asked by smallbusiness on Mar 31, 2012
Latest reply on Mar 31, 2012 by philmodjunk

Title

Multiple Tests in IF Statement?

Post

I would like to be able to print foreign address labels. Some countries put the postal (zip) code before the city, some after the city.

 

What I am trying to do is an IF-type statement, that evaluates the country, then delivers the city line either as postal code, city or city, postal code.

 

Idea (but this test does not work) would be: IF (country = "USA" or "Canada" or "Mexico" ; city & state & zip ; zip & city )

 

Any ideas how to do this efficiently? Thanks!

Outcomes