AnsweredAssumed Answered

Multiple Tests in IF Statement?

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


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!