# Limiting within 360 degrees

This is a discussion on Limiting within 360 degrees within the Excel Questions forums, part of the Question Forums category; I would like to set up a function where values are automatically limited between 0 and 360 degrees. So that ...

1. ## Limiting within 360 degrees

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.

2. Try

Mod(X,360)

3. ## Re: Limiting within 360 degrees

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

4. ## Re: Limiting within 360 degrees

Norie,

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

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

JH

5. ## Re: Limiting within 360 degrees

Originally Posted by jpen
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...

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•