EXCEL中怎么计算COS(211°59′21″-49°)怎么算

来源:学生作业帮助网 编辑:作业帮 时间:2024/04/29 20:08:45

EXCEL中怎么计算COS(211°59′21″-49°)怎么算
EXCEL中怎么计算COS(211°59′21″-49°)怎么算

EXCEL中怎么计算COS(211°59′21″-49°)怎么算
思路:
cos(α-β)=cosα·cosβ+sinα·sinβ
cos(211°59′21″-49°)=cos211°59′21″*cos49°+sin211°59′21″*sin49°
=cos(211+59/10+21/3600)°*cos49°+sin(211+59/10+21/3600)°*sin49°
单元格输入公式如下:=cos(radians(211+59/10+21/3600))*cos(radians(49))+sin(radians(211+59/10+21/3600))*sin(radians(49))
结果:
=-0.977804573