Converting wind direction to angles

[libertyforall]

I am trying to figure out the best way to convert column B
which has wind direction into degrees in a column C. I am using the
following conversion. My column A would have speed; column B would
have direction; column C would have direction in degrees according the
the conversion below.

N 0
NNE 22.5
NE 45
ENE 67.5
E 90
ESE 112.5
SE 135
SSE 157.5
S 180
SSW 202.5
SW 225
WSW 247.5
W 270
WNW 292.5
NW 315
NNW 337.5

 

[Ron Rosenfeld]

I am trying to figure out the best way to convert column B
which has wind direction into degrees in a column C. I am using the
following conversion. My column A would have speed; column B would
have direction; column C would have direction in degrees according the
the conversion below.

N 0
NNE 22.5
NE 45
ENE 67.5
E 90
ESE 112.5
SE 135
SSE 157.5
S 180
SSW 202.5
SW 225
WSW 247.5
W 270
WNW 292.5
NW 315
NNW 337.5

Use a simple lookup table.

In some unused part of your worksheet, M1:N16, for example, place the above
table.

Then use this formula:

C2: =VLOOKUP(B2,$M$1:$N$16,2,FALSE)

This will return #N/A if the entry in column B is not valid.
--ron

 

[Bernard Liengme]

And do remember that if you use trig functions, Excel want the angle in
radians. See functions RADIANS and DEGREES
best wishes