弧度与角度的转换在电子表格里怎么转换?
发布网友
发布时间：2023-08-24 01:57
共2个回答
热心网友
时间：2024-12-04 13:39
假设数据在A1,在B1写公式:
=RADIANS(24*SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A1,"°",":"),"′",":"),"″",))
热心网友
时间：2024-12-04 13:40
sin(-a)=-sin(a)
cos(-a)=cos(a)
sin(π2-a)=cos(a)
cos(π2-a)=sin(a)
sin(π2+a)=cos(a)
cos(π2+a)=-sin(a)
sin(π-a)=sin(a)
cos(π-a)=-cos(a)
sin(π+a)=-sin(a)
cos(π+a)=-cos(a)
tgA=tanA=sinAcosA
2.两角和与差的三角函数
sin(a+b)=sin(a)cos(b)+cos(α)sin(b)
cos(a+b)=cos(a)cos(b)-sin(a)sin(b)
sin(a-b)=sin(a)cos(b)-cos(a)sin(b)
cos(a-b)=cos(a)cos(b)+sin(a)sin(b)
tan(a+b)=tan(a)+tan(b)1-tan(a)tan(b)
tan(a-b)=tan(a)-tan(b)1+tan(a)tan(b)
3.和差化积公式
sin(a)+sin(b)=2sin(a+b2)cos(a-b2)
sin(a)�6�1sin(b)=2cos(a+b2)sin(a-b2)
cos(a)+cos(b)=2cos(a+b2)cos(a-b2)
cos(a)-cos(b)=-2sin(a+b2)sin(a-b2)
4.积化和差公式 (上面公式反过来就得到了)
sin(a)sin(b)=-12�6�6[cos(a+b)-cos(a-b)]
cos(a)cos(b)=12�6�6[cos(a+b)+cos(a-b)]
sin(a)cos(b)=12�6�6[sin(a+b)+sin(a-b)]
5.二倍角公式
sin(2a)=2sin(a)cos(a)
cos(2a)=cos2(a)-sin2(a)=2cos2(a)-1=1-2sin2(a)
6.半角公式
sin2(a2)=1-cos(a)2
cos2(a2)=1+cos(a)2
tan(a2)=1-cos(a)sin(a)=sina1+cos(a)
7.万能公式
sin(a)=2tan(a2)1+tan2(a2)
cos(a)=1-tan2(a2)1+tan2(a2)
tan(a)=2tan(a2)1-tan2(a2)
8.其它公式(推导出来的 )
a�6�6sin(a)+b�6�6cos(a)=a2+b2sin(a+c) 其中 tan(c)=ba
a�6�6sin(a)-b�6�6cos(a)=a2+b2cos(a-c) 其中 tan(c)=ab
1+sin(a)=(sin(a2)+cos(a2))2
1-sin(a)=(sin(a2)-cos(a2))2
其他非重点
csc(a)=1sin(a)
sec(a)=1cos(a)
