【EXCEL】16方位角

Q：如何在excel中表示出16方位角

 

1. 通过平面坐标计算角度

J2=DEGREES(ATAN2((E3-E2),(D3-D2)))

E3：y2，E2：y1，D3：x2，D2：x1

 

2. 通过角度计算16方位

=IF(J2>=168.75,"西",IF(J2>=146.25,"西西北",IF(J2>=123.75,"西北",IF(J2>=101.25,"北西北",IF(J2>=78.75,"北",IF(J2>=56.25,"北东北",IF(J2>=33.75,"东北",IF(J2>=11.25,"东东北",IF(J2>=-11.25,"东东南",IF(J2>=-33.75,"东南",IF(J2>=-56.25,"东南",IF(J2>=-78.75,"南东南",IF(J2>=-101.25,"南",IF(J2>=-123.75,"南西南",IF(J2>=-146.25,"西南",IF(J2>=-168.75,"西西南","西"))))))))))))))))