bpeltzer wrote:

=mod(a1+90,180) will constrain the sum of a1 and 90 to the range of 0-180.



Thanks you - that's excellent.

but how do i contrain sum from 1 to 180 (not 0 to 180)

(so 90 degrees becomes 180 instead of 0)