本文介绍了如何使用Excel的IF函数来计算风向和风速范围，并展示了如何利用OriginPro2021制作风向玫瑰图。在Excel中，通过嵌套IF函数确定16个风向区间和12级风速区间。随后，通过在Origin中导入风向和风速数据，轻松创建风向玫瑰图。
在excel中求算风向和风速范围的函数，用origin做风向玫瑰图
1.在excel中求算风向的函数：
=IF(A2<=11.25,"N",IF(A2<=33.75,"NNE",IF(A2<=56.25,"NE",IF(A2<=78.75,"ENE",IF(A2<=101.25,"E",IF(A2<=123.75,"ESE",IF(A2<=146.25,"SE",IF(A2<=168.75,"SSE",IF(A2<=191.25,"S",IF(A2<=213.75,"SSW",IF(A2<=236.25,"SW",IF(A2<=258.75,"WSW",IF(A2<=281.25,"W",IF(A2<=303.75,"WNW",IF(A2<=326.25,"NW",IF(A2<=348.75,"NNW",IF(A2<=360,"N",0)))))))))))))))))
其中，共涉及16个风向，A2为风向的度数。
2.在excel中求算风速范围的函数：
=IF(C2>=12,">=12",IF(C2>=11,"11-12",IF(C2>=10,"10-11",IF(C2>=9,"9-10",IF(C2>=8,"8-9",IF(C2>=7,"7-8",IF(C2>
最低0.47元/天 解锁文章
扫一扫
982
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
