ALK Technologies - Technology that Drives Transportation - GPS Navigation Evolved

Is there a way to guarantee that distances are always the same in both directions?

A. Yes. Using the PC*MILER|Connect or PC*MILER|Spreadsheets interface products, you can construct a formula to determine the distance in both directions and calculate the average.

For example, in an Excel spreadsheet, if your origin locations are in column A and your destination locations are in column B, rather than entering the formula:
=MILES(A1,B1)
In cell C1, you could enter this formula instead:
=AVERAGE(MILES(A1,B1),MILES(B1,A1))
The resulting distance is guaranteed to be the same regardless of the order of A and B.