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 ...
Here’s a drop-in replacement formula that will work no matter if the imported data is text or numbers, and will always return a valid drift direction (0–360°).
=MOD(VALUE(TRIM(B28))+180,360)
My answers are voluntary and without guarantee!
Hope this will help you.