Limiting within 360 degrees

[orangepeel]

I would like to set up a function where values are automatically limited between 0 and 360 degrees. So that if I enter 361, it returns 1. Enter 400, it returns 40. Enter 1000 it returns 280. etc...
Thanks.

 

[Norie]

Try

Mod(X,360)

 

[orangepeel]

Yeah, that does the trick.
Thanks for a swift reply!
(and only 40 minutes away

 

[jpen]

Norie,

I use the following function. Inputcell is A1. Outputcell is B1.

Function for B1 is IF(A1>360;A1-360;A1)


JH

 

[Juan Pablo González]

Norie,

I use the following function. Inputcell is A1. Outputcell is B1.

Function for B1 is IF(A1>360;A1-360;A1)


JH

That wouldn't work if you enter 800 or 1250 for example...