Formula to find difference between two values

**xcentriq** · 09-25-2017, 11:13 AM

Hi guys,

I'm trying to find a formula that will give me the difference between two values which are angles of a compass.

Example
Cell A = 360
Cell B = 090
Cell C = 270

Cell A is the primary degree
B difference to A = 90 Degrees
C difference to A = 90 Degrees

It must not give me a negative value so it can't be "A+B" or "A-B". only the difference represented by a positive value.

**63falcondude** · 09-25-2017, 11:20 AM

For A and B =MIN(MOD(A1-B1,360), 360-MOD(A1-B1,360))
For A and C =MIN(MOD(A1-C1,360), 360-MOD(A1-C1,360))

**MrShorty** · 09-25-2017, 11:22 AM

I would probably include a simple IF() function (or 2) as part of the calculation to detect when it gives negative values (or values above 180). Something like =IF(B-A<0,B-A+360,IF(B-A>180,360-B+A,B-A)) or something like that.

If that was not suitable, I might consider an approach using trig ratios to convert negative angles to positive angles.