Easiest way is via a vlookup

List the references into cols A and B in Sheet2
N 0
NNE 1
etc

Then in Sheet1,
if wind dir. data will be entered in A2 down, eg: NNE, N, etc
you could place this in B2:
=IF(A2="","",VLOOKUP(A2,Sheet2!A:B,2,0))
and copy B2 down as far as required
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:21,000 Files:365 Subscribers:65
xdemechanik
---
"nelly007" wrote:
I am doing a weather related project, and I need to enter wind data. How
would I be able to enter the wind direction "N" and have it display "0",
NNE=1, NE=2... up to 15 so that it is easier to run a regression analysis on?