求個(gè)excel里能根據(jù)兩點(diǎn)的經(jīng)緯度,求兩點(diǎn)距離的公式,
S==6371000*ACOS(COS(RADIANS(SUM(1*LEFT(C322,FIND("°",C322)-1),MID(C322,FIND("°",C322)+1,FIND("′",C322)-FIND("°",C322)-1)/60,RIGHT(LEFT(C322,LEN(C322)-1),LEN(C322)-FIND("′",C322)-1)/3600)-SUM(1*LEFT(A322,FIND("°",A322)-1),MID(A322,FIND("°",A322)+1,FIND("′",A322)-FIND("°",A322)-1)/60,RIGHT(LEFT(A322,LEN(A322)-1),LEN(A322)-FIND("′",A322)-1)/3600)))*COS(RADIANS(SUM(1*LEFT(D322,FIND("°",D322)-1),MID(D322,FIND("°",D322)+1,FIND("′",D322)-FIND("°",D322)-1)/60,RIGHT(LEFT(D322,LEN(D322)-1),LEN(D322)-FIND("′",D322)-1)/3600)-SUM(1*LEFT(B322,FIND("°",B322)-1),MID(B322,FIND("°",B322)+1,FIND("′",B322)-FIND("°",B322)-1)/60,RIGHT(LEFT(B322,LEN(B322)-1),LEN(B322)-FIND("′",B322)-1)/3600))))的公式,這個(gè)公式有誤差,拿下面的點(diǎn)做實(shí)驗(yàn)
第一個(gè)點(diǎn)：118.9453 39.67206
第二個(gè)點(diǎn)：119.2804 39.58189
用上述公式算出來(lái)得38km,可在googleearth上量出來(lái)30km左右,誰(shuí)知道為什么!怎么解決