EXCEL根据两点经纬度计算距离(共1页).docx

精选优质文档-倾情为你奉上EXCEL根据两点经纬度计算距离方法/步骤1. 1在A2、B2、C2、D2单元格填上两地经纬度。2. 2在E2单元格输入公式=*ACOS(1-(POWER(SIN(90-B2)*PI()/180)*COS(A2*PI()/180)-SIN(90-D2)*PI()/180)*COS(C2*PI()/180),2)+POWER(SIN(90-B2)*PI()/180)*SIN(A2*PI()/180)-SIN(90-D2)*PI()/180)*SIN(C2*PI()/180),2)+POWER(COS(90-B2)*PI()/180)-COS(90-D2)*PI()/180),2)/2)END专心-专注-专业