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!

 

[Tetra201]

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

It's like with hours: 22:00 + 5:00 --> 3:00
Same with degrees: 340° + 50° --> 30°

 

[AliGW]

It's like with hours: 22:00 + 5:00 --> 3:00
Same with degrees: 340° + 50° --> 30°

Light bulb moment! Thanks. I would not have slept tonight ...