在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>