=CityToLatLongWS takes a location and returns the latitude/longitude of a point central to the location.
Syntax
=CityToLatLongWS(location)
Arguments
| Argument | Description | Required? | Values |
| location | A location for which you want to retrieve a latitude/longitude. | yes | A geocodable location in the PC*MILER database. Learn more about how to enter PC*MILER locations. Examples: Princeton, NJ08540 M4C 4Y7 40.420833N,74.561111W new york, ny;118 broadway 191690000 |
| countries | The country or countries where the origin and destination are located. | Not required but recommended for the most accurate geocoding and best performance. | A two-letter country code |
| region | The region of the world where the origin and destination are located. | Not required but recommended for the most accurate geocoding and best performance. | Region Codes are NA (North America), EU (Europe), AS (Asia), AF (Africa), SA (South America), OC (Oceania), MX (Mexico), ME (Middle East), and WW (Worldwide). |