modify a forumla to adjust

**Martindelica** · 02-24-2008, 05:42 PM

Hi there, I need the forumla to adjust when a change in the number pattern changes. Please see attached. It is a little difficult to explain.

Warmest Regards,
Martin.

**shg** · 02-24-2008, 05:59 PM

Maybe you could try. It's not clear to me from the spreadsheet.

**Martindelica** · 02-24-2008, 06:35 PM

The right side is what I want. In order to get the that I need to change the formula in cell M15. You will see that formula in M15 is different from M14. If I didnt make that change I would get the calculation on the lef side which is wrong.

How can I adjust the formula to auto correct the step over 360 in column in E?

Kindest regards,
Martin.

**shg** · 02-24-2008, 06:56 PM

Why not just let all the angles in all columns increase beyond 360 degrees, and take the result MOD 360 at the end?

I.e., add 360 to D15:D30.

**Martindelica** · 02-24-2008, 07:06 PM

Hi Thanks, I tried that too...but not accurate. The only way is get the result on the right is by doing it manually. I was just hoping because of my limited knowledge of Excel that someone on the forum would be able to crack it.

Warmest regards,
Martin.