(U.S. only)

=ZIPCodeWS returns the ZIP code corresponding to any U.S. place name. The place name is a city with a state abbreviation (e.g. Austin, TX).  The function returns a -1 if the place name you entered is invalid. If you enter a city with multiple ZIP codes, PC*MILER will choose the ZIP code designated as the most centralized location in that city. 

The ZIPCodeWS function can be also used to test if a given number is a valid ZIP code. 




ArgumentDescription    Required?Values
locationThe city/state or ZIP code for which you are trying to retrieve or confirm a ZIP code. yesA city and state (with or without the comma). Enter a ZIP code if you want to verify that the ZIP code is valid.

Miami FL
Boston MA

Topeka, KS