=LatLongtoCityWS returns the name of the closest city to the latitude/longitude entered. 


Returns a -1 if the lat/long format is invalid.


Syntax

=LatLongtoCityWS(LatLong)


Arguments

Argument
Description
Required?
Values
location
A latitude/longitude for which you want to retrieve a PC*MILER location.
yes

A lat/long in degrees minutes seconds direction format or decimal degrees format.


Examples:
0401750N,0742131W
40.297222N,74.358611W
40.297222,-74.358611