what is command for instead DEGREES(ATAN2(A2,B2)) formula in excel??
5 ビュー (過去 30 日間)
回答 (1 件)
Benjamin Thompson 2022 年 6 月 4 日
Since -179 and 179 degrees are very nearly equal, those results are actually within the tolerance of your other results. If you used the wrong sign on the "N" component this would explain it, and just keep in mind when very small number and very large numbers are used together in calculations this can lead to odd results. Also is the Excel screenshot showing any rounding, such that the calculations are using additional digits of precision that Excel is not displaying?