2 ms·
My greatest ever accomplishment was implementing this formula in a spreadsheet. I still have it! Here's the cell formula: =ACOS(COS(RADIANS(90−Selector::$Lat))
by LeoPanthera 8y ago
My greatest ever accomplishment was implementing this formula in a spreadsheet. I still have it! Here's the cell formula:
=ACOS(COS(RADIANS(90−Selector::$Lat))×COS(RADIANS(90−N2))+SIN(RADIANS(90−Selector::$Lat))×SIN(RADIANS(90−N2))×COS(RADIANS(Selector::$Lon−O2)))×6371
("Selector" is a table title, I seem to remember - this is an Apple Numbers spreadsheet.)
6371 is a magic number which gives the result in kilometers.
- jasmcole 8y ago6371km is the radius of the earth :)