How does the CDXDistance function which calculates the distance between two zip codes work?
• You can enter a formula directly in an Excel worksheet using the format CDXDistance(ZipCode1, ZipCode2) to calculate the straight-line distance between two zip codes. Enter the actual zip codes or a reference to the cell where the zipcode is located. If you use a cell reference you can then copy this formula to an entire list of requests. Zip codes with leading zeroes should be entered as text, by formatting the cell or entering an apostrophe before the zip code. An easier way is to simply right click on a cell and select the “CDXZipStream option followed by “Insert CDXDistance Function”. Then simply enter the required data in the dialog shown below and the formula will automatically be inserted in the selected cell. Please note that you can also calculate actual driving distance, cost and time between zip codes or addresses with the CDXRouteMP function that works with Microsoft MapPoint.
