## 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.