Showing degrees of wind direction as compass point initials

Here is a webpage that shows the degrees of wind direction and how they apply to the wind rose.

ie: 348.75 - 11.25 = N(North)
11.25 - 33.75 = NNE(NorthNorthEast)

and so on.



http://climate.umn.edu/snow_fence/Co...houttable3.htm


How can I set up a cell that reads a number from 0-360 in a different cell and returns the correct set of initials?

Thanks for any help on this.

Here's a way that is self-contained in the formula:

Please Login or Register  to view this content.

If you don't want a fat formula like that you can have those numbers in one column, and the compass points in another, and replace the parts in braces with references to those columns:

Please Login or Register  to view this content.

@ Cutter: Thanks for putting that table together. It's more elegant than my solution, that's for sure.

maschette,

Welcome to the Forum, unfortunately:

Your post does not comply with Rule 2 of our Forum RULES. Don't post a question in the thread of another member -- start your own thread. If you feel it's particularly relevant, provide a link to the other thread. It makes sense to have a new thread for your question because a thread with numerous replies can be off putting & difficult to pick out relevant replies.