作者:乔山办公网日期:
返回目录:excel表格制作
角度单位度转换为636f7079e799bee5baa6335弧度的Excel函数是RADIANS,弧度转换为度的Excel函数是degrees。但是这中间的度是以小数的形式表示的而不是以楼主所述度分秒形式表示的。
度分秒转换成度,可以用下面的公式(假设度分秒数据在A1单元格)
=ROUND(A1,0)+ROUND((A1-ROUND(A1,0))*100,0)/60+ROUND((A1*100-ROUND(A1*100,0))*10000,0)/3600
所以,你的公式比较复杂。可以这样写(B列是转角,C列是方位角)
=if((ROUND(B1,0)+ROUND((B1-ROUND(B1,0))*100,0)/60+ROUND((B1*100-ROUND(B1*100,0))*10000,0)/3600 + ROUND(C1,0)+ROUND((C1-ROUND(C1,0))*100,0)/60+ROUND((C1*100-ROUND(C1*100,0))*10000,0)/3600)+180 >360,(ROUND(B1,0)+ROUND((B1-ROUND(B1,0))*100,0)/60+ROUND((B1*100-ROUND(B1*100,0))*10000,0)/3600 + ROUND(C1,0)+ROUND((C1-ROUND(C1,0))*100,0)/60+ROUND((C1*100-ROUND(C1*100,0))*10000,0)/3600)+180 - 360 , (ROUND(B1,0)+ROUND((B1-ROUND(B1,0))*100,0)/60+ROUND((B1*100-ROUND(B1*100,0))*10000,0)/3600 + ROUND(C1,0)+ROUND((C1-ROUND(C1,0))*100,0)/60+ROUND((C1*100-ROUND(C1*100,0))*10000,0)/3600)+180
为了便于理解if函数的内容,分几行写如下
=if(
(ROUND(B1,0)+ROUND((B1-ROUND(B1,0))*100,0)/60+ROUND((B1*100-ROUND(B1*100,0))*10000,0)/3600 + ROUND(C1,0)+ROUND((C1-ROUND(C1,0))*100,0)/60+ROUND((C1*100-ROUND(C1*100,0))*10000,0)/3600) +180>360
,(ROUND(B1,0)+ROUND((B1-ROUND(B1,0))*100,0)/60+ROUND((B1*100-ROUND(B1*100,0))*10000,0)/3600 + ROUND(C1,0)+ROUND((C1-ROUND(C1,0))*100,0)/60+ROUND((C1*100-ROUND(C1*100,0))*10000,0)/3600)+180 - 360
, (ROUND(B1,0)+ROUND((B1-ROUND(B1,0))*100,0)/60+ROUND((B1*100-ROUND(B1*100,0))*10000,0)/3600 + ROUND(C1,0)+ROUND((C1-ROUND(C1,0))*100,0)/60+ROUND((C1*100-ROUND(C1*100,0))*10000,0)/3600+180
)
---------------------------------------------------------------------------
建议单独设置一列,计算度分秒转换为度,隐藏起来。