excel计算两点经纬度距离
问题描述:
excel计算两点经纬度距离
A B C D E
1 A点经度 A点纬度 B点经度 B点纬度 距离
2 116.69546 39.583514 116.69586 39.583544
答
=111.12*COS(1/(SIN(B2)*SIN(D2)+COS(B2)*COS(D2)*COS(A2-C2)))你好,这两点在谷歌地球上测算的距离是34.49米,计算出来的不对啊?=6371004*ACOS((SIN(RADIANS(B2))*SIN(RADIANS(D2))+COS(RADIANS(B2))*COS(RADIANS(D2))*COS(RADIANS(C2-A2))))角度需要转弧度计算。