Add or subtract polar degrees in Excel
Add or subtract polar degrees in Excel
(OP)
Can some one please show me how to add or subtract polar degrees in MS Excel (2003).
I have two polar values (anywhere from 0 to 360 degrees), A1=10 A2=359.5 A3=MOD(A1-A2,360)which returns the correct value of 10.5
But.. if A1=350 and A2=359.5 A3=MOD(A1-A2,360) returns 350.5 and not the correct value of 9.5 degrees. Can this be fixed with a pile of "IF" .. THEN" statements.. or there must be a better way
Thank you for your time, it is very much appreciated.
Ralph
I have two polar values (anywhere from 0 to 360 degrees), A1=10 A2=359.5 A3=MOD(A1-A2,360)which returns the correct value of 10.5
But.. if A1=350 and A2=359.5 A3=MOD(A1-A2,360) returns 350.5 and not the correct value of 9.5 degrees. Can this be fixed with a pile of "IF" .. THEN" statements.. or there must be a better way
Thank you for your time, it is very much appreciated.
Ralph





RE: Add or subtract polar degrees in Excel
TTFN

FAQ731-376: Eng-Tips.com Forum Policies
Need help writing a question or understanding a reply? forum1529: Translation Assistance for Engineers
RE: Add or subtract polar degrees in Excel
My simple spreadsheet,
A1 350 degrees
A2 10 degrees
A3=MOD(A1-A2,360) which returns 340.. which is correct but I want it to show 20 degrees.
RE: Add or subtract polar degrees in Excel
RE: Add or subtract polar degrees in Excel
=MIN(MOD(A1-A2,360), 360-MOD(A1-A2,360))
RE: Add or subtract polar degrees in Excel
RE: Add or subtract polar degrees in Excel
RE: Add or subtract polar degrees in Excel
RE: Add or subtract polar degrees in Excel
The solution that MintJulep (Mechanical) gave me is doing exactly what I wanted.
=MIN(MOD(A1-A2,360), 360-MOD(A1-A2,360))
RE: Add or subtract polar degrees in Excel
In most applications (balancing for example), it would be important to track the polarity (sign) that results from vector subtraction. But we don't know his application.
=====================================
(2B)+(2B)' ?
RE: Add or subtract polar degrees in Excel
Maybe I should have just said he wants to know the distance between two angles, expressed as an angle less than 180 degrees, without regard for the polarity.
=====================================
(2B)+(2B)' ?
RE: Add or subtract polar degrees in Excel
=====================================
(2B)+(2B)' ?
RE: Add or subtract polar degrees in Excel
RE: Add or subtract polar degrees in Excel
Polarity is maintained. If you want the absolute value, just add that function to the string.
But forces have magnitude as well as direction, so vector subtraction as electricpete suggested may be appropriate.