=CityNameWithCountyWS takes a PC*MILER location and returns the city name with state and county. Any PC*MILER location (city-state, postal code, six-digit Canadian Postal Code, PC*MILER Worldwide international postal code, SPLC, PC*MILER custom name) may be entered. (Applicable licensing applies for certain types of data.) 


Returns -1 if the PC*MILER place you entered is invalid.


Syntax

=CityNameWithCountyWS(location)


Arguments

Argument
Description 
Required?
Values
location
A location for which you want to retrieve the city name with state and county.
yes
A geocodable location in the PC*MILER database. Learn more about how to enter PC*MILER locations.

Examples:
Princeton, NJ

08540

M4C 4Y7
40.420833N,74.561111W
new york, ny;118 broadway
191690000