Stephan Bielicke wrote:

Hello,

schrieb
Please see below ( I want to do step 3 - change a value by 90 degrees)
but the answer has to be between 0 and 180

e.g. 45 becomes 90

? 135 ?

e.g. 95 becomes 185 (but this is wrong, so SUBTRACT 90 instead) anwer is 5

try
=MOD(A1+90;180)
if a1 contains the original value.

HTH
Stefan


thanks for correcting my maths!

=MOD(A1+90;180) didn't work - I replaced the semicolon ( ; ) with a
comma ( , ) - you probably meant this