Making a max value reset

[Mlee107]

Hi everyone!

My first time posting here as I seem to have hit a wall haha


I'm trying to get the number to reset. So If the number goes above 360 to get it to start counting from 1 again.

My current formula is:
=IF(SUM(D2)>=360,360,SUM(D2))+82.5

I am able to get the max number to 360 but it should be 82.5

For example if my value was 300+82.5 the outcome would be 22.5

Any help is greatly appreciated!

 

[AliGW]

I'm struggling to make sense of your formula - why are you using SUM with a single cell?

For example if my value was 300+82.5 the outcome would be 22.5

How? Why?

 

[Mlee107]

I'm struggling to make sense of your formula - why are you using SUM with a single cell?



How? Why?

You know I don't even know why I have SUM there haha.. I'm really new to Excel.

The reason for the max being 360 is that it's for (bearing / degrees). So if the number is greater than that I need it to reset back to zero as if it were a circle.

 

[AliGW]

OK - understood. Can you give us a selection of sample data? How does this look in your worksheet?

 

[Tetra201]

... The reason for the max being 360 is that it's for (bearing / degrees). So if the number is greater than that I need it to reset back to zero as if it were a circle.

Is this what you need?

=MOD(D2+82.5,360)

 

[Mlee107]

Is this what you need?

=MOD(D2+82.5,360)

That's the one! Works perfect.

Thanks for the bloody fast help guys. Appreciate it!

 

[Tetra201]

You are welcome.

 

[AliGW]

Ditto, but I still haven't a clue what you were trying to do! I'm glad Tetra201 understood ...

 

[Tetra201]

@AliGW:

First: What a nice hat!

Second: The '360' from Post #1 gave me some suspicions. The 'bearing / degrees' from Post #3 made everything clear.

 

[AliGW]

It hasn't made anything clearer to me, I'm afraid!