How to change wind in degrees into wind directions in excel

=CHOOSE(ROUND(A2/45,0)+1,"N","NE","E","SE","S","SW","W","NW","N")

[@ianl1052]

Thank you once again for an interesting tutorial. Am I right in assuming you inserted 3 pie charts? If yes, how and how did you get the 22.5 degree divisions with markers? I tried a few times and failed miserably. In the end, I cheated and took a screenshot of all 3 together and pasted it into my sheet.

[@ramsisxii3695]

Madam, when I enter the equation, it tells me an error

[@ianl1052]

Look again at your formulas. I followed Karina along step by step with no problems.

[@ramsisxii3695]

@@ianl1052 Indeed, the fluency was between a mistake