Create a lookup table of the form

0 N
3 NE
7 E
10 NW
....
33 N

that is just create an entry for the lowest number of each point (including
duplicating for N in 33, etc.), and assuming that tab le is ih H1:I10, use

=VLOOKUP(A5,$H$1:$I$10,2)

adjust the lookup range to suit


--

HTH

RP
(remove nothere from the email address if mailing direct)


"John T. Sheedy" <John T. wrote in message
...
I have a list of numbers 0-35 that I have to convert to 8 compass
directions(N, NW, E, ECT.). I used the IF function to search but the
string
doesnt work. I tried using an array {1,2,3,33,34,35} for north and it
comes
back as false even thought the search number is 35

This is a sample of the finction I am using

=IF(A5={0,1,2,33,34,35},"N",IF(A5={3,4,5,6,},"NE", "NW"))
I carries this formula out to the 7 argument limet and am using the NW to
represent the last compass direction.

Please help

John