Excel自动算两坐标点方位角的公式,要正确,最好显示的是度分秒,还有随机变量在正负0.003与0.009之间的公式,就是0.003~0.009,-0.003~-0.009。谢谢了
åªä¸ªæ¯X1Y1,X2Y2
追çx1:a1,y1:b1
x2:a2,y2:b2
ä¸ä¸æ¡å
¬å¼å¿äºèèè¶
180°ï¼æ´æ£å¦ä¸ï¼
æ¹ä½è§å(-180,180]:
=IF(DEGREES(ATAN2(A2-A1,B2-B1))>=0,"","-")&TEXT(ABS(DEGREES(ATAN2(A2-A1,B2-B1))/24),"[h]°mm\'ss\""")
æ¹ä½è§å[0,360):
=TEXT((IF(DEGREES(ATAN2(A2-A1,B2-B1))>=0,0,360)+DEGREES(ATAN2(A2-A1,B2-B1)))/24,"[h]°mm\'ss\""")