Forum Discussion
Data Import issue???
I am working on a drift formula for items being pushed by wind and waves on the water. I imported a text file of weather data, formatted all the data to numbers, and built an "if" formula to convert ...
In the world of Excel text is taken to be greater than any number. The simplest way of coercing text to numbers is to use it within an arithmetic expression so
driftDirection
= MOD(windDirection + 180, 360)