Multiple Tests in IF Statement?
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!