Clock Arithmetic or completely wrong track?

[Bod]

Hi,

Kind of admitting defeat by posting this but this has me stumped. Can't find solution on web but maybe searching on wrong terms.

Here's my prob....

I'm using Excel to plot the coordinates of circles and arcs for loading into Google earth. I want to build the arc based on a center bearing and width left/right of the bearing. Eg like the sketch below an arc on bearing 60 and +/-40 degrees:
\1

My starting approach was simply to add/minus the left/right value (eg 40) to the center bearing, using MOD function to roll over. That works fine most of the time as I can then use an IF statement to evaluate if a particular bearing is within the arc (i.e if(degreevalue>=centerbearing-widthvalue....

Where I'm having probs is where the arc crosses over the "roll-over" point in the circle.

So, I have a list of degree values, 0 to 359. I have a centre bearing (eg 60) and a left/right degrees value (eg 40).

What formula can I use to evaluate whether a degree value is within the arc?


Sorry if this isn't clear

[ConneXionLost]

Hi Bod,

If your list of degree values starts at 0 degrees in cell A1, and increases down the column until it reaches 359 degrees in cell A360. Place your center bearing value is in cell D1, and the width value in cell E1.

Place this formula in cell B1, and auto-fill it down to cell B360:

Please Login or Register  to view this content.

HTH

Cheers,

[Bod]

Wow! Thanks, yes that worked like a treat.