Distance Measuring

Factual Questions
1

I want to measure the distance between two points on the globe (from any city in the world to another, LA to Sydney(Aus) say for example). I know the longitude and latitude for each city. Is there a formula that would convert this information to a distance in miles or Km?
I’m interested in ballpark results (say ±10% from true distance) so the formula doesn’t have to be overwhelmingly complicated.

I know I can google each individual city and find out but it would take time. I want a formula that can be used in a spreadsheet to calculate a matrix of many cities without having to search for each one on some website.

Thanking you all in advance.

2

Have a look at this: Calculate distance and bearing between two Latitude/Longitude points using haversine formula in JavaScript

3

Here is another possibility that I found out from a different SDMB thread a while back.

The creator of that site has a separate page that lists the code used. Hopefully you can use that to come up with your own spreadsheet equations.
Another tack would be to use the Wikipedia entry to come up with the spreadsheet formulas. Great-circle distance - Wikipedia

4

I give you Aviation Formulary - exceedingly useful (if perhaps a bit more than necessary).