> 其他 >
已知经纬度,如何用Excel计算两点间距离
人气:282 ℃ 时间:2020-02-05 15:20:39
解答


公式:

=6371004*ACOS((SIN(RADIANS(B2))*SIN(RADIANS(D2))+COS(RADIANS(B2))*COS(RADIANS(D2))*COS(RADIANS(C2-A2))))
推荐
猜你喜欢
© 2026 79432.Com All Rights Reserved.
电脑版|手机版