Spreadsheet calculation
All I am trying to do is put in equation form the angle between wind and a track in order to calculate h/w and t/w components.
For example, wind 270, track 340 is 70 deg off. It works like (W-T)*-1 or wind 270, track 020 is 110 deg off but it would be 250 so a 180 has to be thrown in. I ended up with so many different permutations it made my head spin and there has to be an easier way.
I never was any good at programming logic perhaps one of you can come up with a simple "if X then Y=Z" kind of thing.
Thanks in advance.
SS